There were/are a few videos of Asonimie trying rogues during Cata-Beta.
With equal gear (full pvp gear) they took out a lot of equal/larger groups.
This was in PvP play, mostly battlegrounds and some world play.

For PvE...
You have the initial Sap.
You can fairly easily macro Blind to a Focus target, for in-combat CC.
Not sure the spec you would use for PvE play.
They'll likely do more from backstab if possible; then again Combat Swords/Maces or Mutilate probably doesn't require much facing...
As always, you're best off if melee (any melee) are behind the mob and the mob only faces the tank.

Rogues would suffer the same as other melee.
Namely being in melee/cleave/pbaoe range of the boss.
On fights without a lot of movement, they're extremely good damage.
They have a lot of interrupts, if you need those too... kick, gouge, kidney shot, etc.

If you're running them for PvP.
Recuperate is better healing than rogues have ever had previous.
Unless of course you run with a healer.

I was primarily interested in PvP.
Which is why I went with Ferals instead of Rogues.
The everyone-can-heal and everyone-can-rez things.
Stealth for PvP is quite nice.

I would look at the two-step macros either Mercurio's or Toned's or possibly Aragent's which are all forum stickies.
Decent places to start.