You will enjoy every facet of Rogue play, minus your role in some premades, should you choose to rank.
They aren’t amazingly-fast at leveling, but they solo just fine and have so many escape mechanisms in their toolkit.
They are premier damage dealers, and as such, not having any role besides doing damage, people expect nothing of you besides that. No one relies on you to CC, but when you do land a clutch blind, or you gouge a mob off of a healer in a dungeon, people will absolutely notice and generally appreciate you more so. They scale incredibly-well in every facet of raid content.
They are magnificent in world PvP. I don’t think I need to elaborate there.
One of my absolute favorite things, was when I needed to go AFK, I climb a hill off the beaten path, eat food to regen, and stealth. No one to gank me, especially when there’s nothing there to gank.
They farm dungeons very well. You can pickpocket Stockades for almost 2g/run, starting at level 25. It takes 10 minutes a run. You do that 10 times a day, spending less than 2 hours, for a week, and you have 70g-100g before you hit 40, absolutely assuring yourself of a mount when you ding, among extra gold for engineering, skills, or maybe even some good gear. As you ramp up in levels, so does the gold. Clear out all 3 wings of SM at level 38 for around 15g. Do that for a week and hit your 40s with 200-300g. Do that in RFD and hit your 50s with 500-800g. Do that in BRD and have a steady supply of gold for alts, epic mount, max enchants. Sky’s the limit.
The only thing you will have issue with, is the enormous amount of Warriors and other Rogues competing with you for gear. If you are a good player, polite, patient, and do your job damaging, you’ll get your gear and be able to do anything else that much better.
It is easily one of the best classes to play and start with on Vanilla.