Depends on the game, and the type of RPG in question.
In an ARPG (action RPG), I tend to try and approach them with a balance of offense and defense.
Specifically, in a game like Dark Souls and the like, I tend to go on the defensive and analyze the enemy for weaknesses. For an RPG like Diablo, I go for DPS or offense.
In a turn based RPG, depends on the game in question.
For DND and Pathfinder, I tend to like Paladins, Fighters, and Barbarians a lot. Using magic in DND and Pathfinder requires you to keep track of spell slots and such. It's fun, but I don't like constantly having to reference the Player's Handbook just to cast a spell. The Paladin is on my level though. One spell. And that's
SMITE!!!
Also, for DND and Pathfinder, it depends on who the DM is, but in encounters, I tend to work with the group, with me currently playing the role as a tank, thanks to his decent HP, strength, and an AC that I'm surprised is as high as it is. Also depends on if I prayed to RNJesus, because some nights, my rolls are awful, and others they are raw 19's.
For a game like Dragon Age, specifically, the first game, I play a mage healer enough to get group heal, then specialize again in arcane warrior for
massive amounts of DPS, combined with spells. Seriously, Spirit Healer + Arcane Warrior builds almost break the game.
In the Witcher series, I tend to get too aggressive, compared to my normal approach of offense + defense.
So it depends.
The only time I get really aggressive is spectacle fighters like Ninja Gaiden: Black, Bayonetta, DMC, and such. But those aren't really RPG's, so they don't count.