Nassau is Nassau. It is a tourist port that doesnt really change. If you are not doing a booked shore excursion or heading to one of the hotels on the island with a day pass - just chill and wander about the couple block area of downtown Nassau for a little shopping and a little drinking. Honestly, not much else to do. The straw market is just dime store junk at this point, and you are harassed by drug dealers and counterfit purse people outside of it - and of course young kids trying to "give you a gift" of a free necklace which is just a ploy to get money - and to see where your money is. The people in the shops are nice, but after a few blocks you will realize it is the same stuff over and over and over again in the shops. Love the Pirate's of Nassau and always make a quick stop there.
We usually wander for an hour or so and then head back to ship. Its a nice way to stretch the legs a bit back on terra firma And of course, Senor Frogs is always good for some entertainment.
Its the pool deck from the ship with sand and some excursions ($30 for snorkeling equipment, and pay to rent floating mats is a little much) I am assuming when there are more than one or two ships in port, it is a night mare and crowded (we were just there with the Sky (<2000 peeps) and it was crowded. Not many places to go other than lounge chair and bar. Good thing is you dont need money for the bars (just room key) BUT you do need cash for the shops - and it is the same exact stuff you find in nassau.
But that said, NCL is looking to expand - and hopefully clean up some of the beach (too many rocks in the water to enjoy swimming, etc. - hard to walk).