If you enjoy Star Wars, then Knights of the Old Republic II: The Sith Lords has one of the best stories around, completely deconstructing the entire Star Wars mythos and its shitty light vs dark dichotomy.
Other than that, the Metal Gear Solid franchise gets a lot of flak for its convoluted-ness, but if you just play the first 3 (not counting the MSX games), the story actually makes perfect sense with no major plot-holes, although you may need to play 2 more than once.
Other than that, the Metal Gear Solid franchise gets a lot of flak for its convoluted-ness, but if you just play the first 3 (not counting the MSX games), the story actually makes perfect sense with no major plot-holes, although you may need to play 2 more than once.