First released as a PS2 title, then ported to PC in 2003 (and ported really well), it's by Konami. Not quite what I expected from them though as it channels The Longest Journey, Pathologic and Fahrenheit/Indigo Prophecy.
Plotwise it's about a young man in the present day who gets stabbed, but then through mysterious forces is brought back to life to prevent his own murder, and given a time travel device in order to do so. He goes back in time 30 minutes before his death and puzzle solves to prevent it, but then is killed again 30 minutes after he originally died. A game of cat and mouse ensues and the character travels to 1979, 1902 and 1580 to investigate and change things that impact on whether he lives or dies in the future.
It takes place in a single Germanic town, which we see in these different time periods. This adds to its charm, as the character names are all Germanic, the characters are Silent Hill style and the voices are a mix of American and British! I like the immersion and we get a real sense of place through roaming its Pathologic-esque streets and talking to its inhabitants. The puzzles make use of the time element well, e.g. when you're back in time it shows a clock counter of the time where you are but also in the present where you need to puzzle-solve before a certain time.
Anyway, I'd never heard of it before a few days ago, but if you're into adventures like Broken Sword it's really worth getting a copy off ebay. I'm almost finished and looking forward to playing through its 7 endings!