Baldur's Gate 1&2, Fallout 1&2, Arcanum, Vampire: The Masquerade: Bloodlines, Planescape: Torment, System Shock 2 (although that's more atmospheric than compelling), Deus Ex.
Fallout 3 has plot holes large enough to drive the Enterprise through, Mass Effect is the same as all Bioware stories...