When I started raiding, back in the Karazhan days, I was the only rogue in my guild that was level 70. Others had leveled rogues for a while, but not to max level. At that time, I was competitive for top dps, but couldn’t quite keep up with our hunters.
We made an alliance with another guild to raid Gruul and Magtheridon, and there were a total of three rogues in our 25-man raids. The three of us routinely finished at or near the top of the meters with an occasional mage, warlock, or hunter mixed in. Eventually one left for a more progressed guild and the other stopped playing, and we went into WotLK as a one-rogue raid again.
All through WotLK and into Naxxramas and Ulduar I was the only max level rogue in the guild for any length of time. I sat at the top of the damage meters from start to finish, and have continued there.
A funny thing happened along the way… our shadow priest rolled a rogue alt, got it to max level and made it his main. Then our DK got a rogue to max level and switched it to his main as well. And one of our mages switched to a rogue as his raiding toon, also. As they leveled, they all told me how much fun the rogue was to play, both in PvP and PvE. Now in my guild there are between two and four rogues in every raid. Also, there are an assortment of rogue alts at various stages of leveling. I don’t expect them all to make it to max level or to raid. But they are having plenty of fun.
Even Blizzard thinks its a great playstyle. Remember, in the Rogue Q&A when they said, “Overall, we really like the way the combo point and finishing move system works. If anything, the risk is that we could push too many other classes towards this system, which makes it less unique for the rogue.” That, plus the fact that rogues get very few changes in each patch, tells me that the class is playing well.
I’m not about to say that rogues are for everyone. But if you haven’t tried it, you should.