Mass Effect 1 (the second one's plot is subpar)

Avoid Dragon Age, it's bad.

Baldur's Gate (I & II)
Planescape Torment
Vampire Bloodlines
Arcanum
Fallout New Vegas
Drakensang I & II
Mostly old games cause new ones are usually pretty bad on the RPG departement.