I play all kinds of games, like GTA games, Worms series, Hitman series, Burnout Paradise city, Flatout games, Hotline Miami, Far Cry series, Half Life, Civilization series, Fallout series, Arma series, Left 4 Dead games, and alot of others.
I play Hitman just for sake of roleplay as "a hired killer who gets paid when contract is done". I kind of liked HBM because you got money for your contracts which you could spend on upgrades, and other stuff which is nice.
Fallout games are good for roleplay, but unfortunately its not in that way of roleplay. The thing is that it would be nice if instead of "great plot" it had an setting, interesting characters/locations/weapons, and at the begining of the game you kind of fill out who you are, which faction you are in, why, etc. Now this is an roleplay. Fallout New Vegas kind of did that by giving an player as less background as possible just for sake of roleplay (and unfotunately still retained it's plot. Shame.).
Since i occasionaly love to bring the destoy things (in game), i play games like flatout and burnout, GTA. I can't say much about GTA, but i can say that burnout is a good racing game, unfortunately it doesnt has an stong fan base which is why it's not popular. Same with flatout, fan base is there, but its kind of slowly dying with each year.
Oh another good roleplay game i have is Mount and Blade. It's practicly an god send game for roleplayers like me, because you actually have a choise over your character background, it has it's world and setting and characters. There's still alot of room for improvement, such as improving the mechanics of the game (especialy skills, choises of answers, A.I. behavior, etc). Still, game is solid grade "A" for me.
I hope we could see an game like Dungeon Keeper with the setting of Hitman, where you control ICA, train your agents, send them contracts, getting paid, imroving. All of that. I wanna see it :3