I dunno about all that, we stayed in Nassau for our honeymoon almost 5 years ago. We had a blast (honeymooning aside). Spent a few days at Atlantis to do the waterpark/expensive restaurants stuff, then moved over to the Nassau Hilton for the rest of the week to stay a bit more out of the tourist traffic (as much as one can in Nassau). Granted, we didn’t try and venture too far off the reservation, but we met plenty of nice people and were there during Halloween which was fun as well.
If we went back to Bahamas, we’d probably try to go to one of the outlying islands to escape most all of the cruise ship tourism part, but I wouldn’t tell anyone to avoid Nassau, but just know what to expect in a country which exists pretty much solely due to tourism.