Hey folks, I'm one of the cruise critic people that are going to Sunset Beach resort. I've been there before in Dec '05. It's not a Carnival excursion. When we got off the Conquest in Mo'bay, we hopped on a shuttle to go to a shopping area. We went in a few shops and weren't real impressed, so we grabbed a cab told the driver we wanted to go to Sunset beach resort and before we knew it, we were there. From what I remember you DO have to relinquish your S&S card and get it back when you leave. Not sure why, but there is a cruise passenger discount and you have to prove you are from a cruise.
The same driver was supposed to pick us up that afternoon at a specific time, but he was running late (passed him on the way back) and I was getting antsy about getting back to the ship. Anyway there were plenty of cabs to get us back to the ship.
As for Sunset Beach itself, we loved it enough to go back this time. Plenty for us to do, ok food(realize it's not gourmet quality), and open bar.