I played for about a year during TBC, and picked it up again when Cata released. Been playing this go round since about December.
Honestly, if you think is the kind of game you might like, i say give it a go.
I would rank WoW within the best 3 gaming experiences of my life. A large part of that may drive from the social aspect however, being part of a good, close knit guild really adds to the experience.
Lots of people are wary about the sub fee, but honestly, I SAVE money playing WoW, because I am not buying every other new game that comes out, just to play for a few weeks and shelf out of boredom. And you do get what you pay for. There is so much content to go through, and they are continually adding new raid content, new daily questing zones, etc etc. There is also tons of replay-ability, in the sense that even after you get a toon to max level and gear up, you'll probably want to level a 2nd or 3rd toon to play with as well.
PSN / Steam - KrimsonStudios