I thought the first Vampire CRPG, Redemption by Nihilistic Software, was crap. Vampire is a game of politics and they turned it into an action title. But I'm not going into that right now.
The thought of a Shadowrun video game seems impossible at the moment because of numerous reasons, though I think there are two main reasons why it hasn't happened yet: it would take a long time to produce a game that was able to include everything present within the SR universe and most Game Designers would be unwilling or unable to take on such a project because of the game's complexity. Most good game designers are afraid to stray from the first rule of game design which is KISS meaning Keep it Simple, Stupid. And those who aren't afraid of breaking said rule have probably already been fired because they took too many things too far and ended up slaughting some game title. It's sad to see the games industry in such a possition where most designers are unwilling or unable to take the steps to create a game that is revolutionary rather than just evolutionary.
At least until recently. Troika's staff has done some excellent work in the past on such titles as Fallout, Arcanum, and more recently, the Temple of Elemental Evil (so long as one doesn't mind the consistant game crashes). While their games aren't perfect from a more technical standpoint, they've shown the ability to create beautiful and unique worlds filled with interesting characters.
One of their current projects is a Vampire: the Masquerade title called, "Bloodlines," which promises to hold true to the original Vampire game unlike Redemption where one could run in front of a bunch of cops, carrying a minigun without worry of being attacked...Or so says PC Gamer, though a gaming website called Game Banshee is making different claims.
Regardless, the latest Vampire title promises all the usual weapons one can find in any other First Person Shooter, but also has the addition of Vampiric powers or Disciplines.
Now, Vampire may be an entirely different game from Shadowrun, but I'm certain that the game and engine wouldn't need that much modding to make a good Shadowrun Total Conversion. I've been toying the possibility on leading such a project, though seeing as how I have no experience modding video games...
Eh, we'll see.