Not tried Condemned no
Its made all the way back in 2005 (a year after Bloodlines), guess they made better games back then :D
I played Condemned at the time and while the first person melee was great, I hated the fact that the weapons disintegrated. This was as stupid as in SS2, but at least it made some sense because you were supposed to be outnumbered! In Bloodlines on the other hand you are a powerfull vampire, even as a fledgling, and you had all the choices, you could play it as a talker, a sneaker, a brawler or a shooter or mix up all of these. Why throw that away and force people into one direction? That was a bad design move right from the start.
I think a compromise is possible, you would keep the guns but special ammo that actually was able to do more than tickle vampires and supernatural beasts were a rarity, guns were for humans, that is it. Guns with normal ammo would at best stun and weaken higher generation vampires and weaker supernatural beasts but not damage to kill them, only headshots from higher caliber weapons would be somewhat effective with normal ammo. Also, you were a thin blood, even Sabbat trash were more powerful than you, so you being overwhelmed by ghouls, low tier vampires and other thin bloods wasnt lore breaking.
It would be cool, the Prince sending you on a mission, a building was occupied by hobos and he wanted you to evict them on a way or another, he doesnt want to involve the police. So he sends you, what he didnt tell you is that he didnt want to involve the police because he suspects something fishy is going on that building complex where the hobos are, some charity organization was in there but he suspected that it was hiding something, your goal was to discover what, if you died trying, you were a thin blood, nobody cared about you anyway.
In the end, after initially slaughtering the hobos with ease, you discover there is a Tzimisce in there that was experimenting with thin bloods and he attracted a few in there that seek a "cure", but the Tzimisce wasnt exactly interested on a cure but experimenting on thin bloods because he was interested on their ability of having visions with Antediluvians and wanted to know if that could be learned for the Sabbat. As soon as you tell the prince what is going on, he tells you to get the hell out, however the Tzimisce has other plans. You have to fight sabbat goons, thin bloods and abominations to get out. If you manage to get out, the Tzimisce later sends a mensage to you with an offer claiming he has the knowledge how to reduce your generation, you only need to join the Sabbat and become a spy on the Camarilla as he knew the prince was the one that sent you there.