Clive Barker's Undying
It actually looks too crisp for that but it's the first thing than came to mind.
I admittedly haven't played Undying myself yet but I don't see any similarities here. o_O
Oddly familiar. But on the other hand I think I've never actually played it but just seen it (probably one of my friends showed me that). The conclusion is: it's probably a console game...
Actually I only played it on PC and didn't think there were console versions but I just checked and indeed, it seems to have originated on consoles.