I'm kind of 'eh' on Vegas. It kind of reminds me of NYC in the sense that if you have a lot of money you can have a fantastic time. If you don't, it's a little harder.
I'm going to Vegas for a bachelorette party in a couple weeks. I'll be there for less than 24 hours (flying in at 9:00 in the morning on Sat, and then leaving early Sunday) so I don't think I can get sick of it. I actually haven't been back since 2003, so I'm kind of looking forward to it.
But in general I wouldn't choose to go to Vegas. I do like slot machines and gambling in small amounts, but have no desire to gamble all night. I do like good food and drinking and staying up late on vacation, but I feel I can do that anywhere. I don't like the weather, smoke, and icky porn people.