I have a list of games that I love and not many others play:
TIM i.e. The Incredible Machine - I have not met another person who played this game, but it rocked. You basically had to solve puzzles using a set number of pieces that they gave you, each of which had a different use.
Civilization 2 - Yeah, this one is pretty well known however it is still not praised enough. What makes this game truly incredible is that not only is it a solid and fun game, but you can then copy the game and change EVERYTHING. The game even puts the rules into a text file and tells you how to edit them! All the units and such are also located in .gif's for editing as well. The expansions then allowed .bmps to be read and created an easy-to-learn scripting tool for scenarios. If anyone has not played the Lord of the Rings scenario for this I will give it to you, as it is the absolute best piece of work for this game ever.
Legend of Mana (Playstation) - When I first played this game, I took a look at the characters and thought "what the..?" I continued playing, though, because the game system is SO addictive and customizable. As I played, I began to understand the story more and more and it hit me what genious went into this game. Moreso than any Final Fantasy this game (along with the complex Chrono Series) shows off the brilliance that Square can create, provided they don't rehash mainstream themes with angsty teen characters.
I may think of more but that's it for now...
Cool People: Harrison Ford, Vivaldi, and the entire crew of TSO.