It is ever since games like Bioforge (released in 1995) that put you into the role of a character and let you live their adventure that I have been hooked on this kind of play style. These games let you influence the story like a movie that you are an actor in, and give you a real sense of progression as your character's skills improve.

To me, Cyberpunk is the current crowning of cinematic RPGs. It has all the elements that make a great story, and goes above and beyond to let you inhabit the role of the main character.