I'm not a fan of RPG's personally. I like a lot of the old school mid to late 90's 2D computer games. They were the best. If I had to pick a RPG from today... its more of a RPG/First person, i'd pick Day of Defeat Source.
I wouldn't exactly label DoD as an RPG/FPS, it's 100% FPS.
Well you might enjoy Pirates!: Live The Life. I've played that a couple of times, and it's pretty good. Stays true to the original.
Another game I would recommend is Deus Ex. It's an RPG/FPS with a good story. There's also Fallout 1 & 2, if you like isometric RPGs.
Finally, there's Vampire The Masquerade: Bloodlines. That's also an RPG/FPS, which focuses more on melee combat. If you do get it, I recommend you install the latest official patch, and the latest unofficial patch, as it has a ton of bugs. Depite that, it's a cool game, with multiple endings.