The only interesting thing I saw in this thread is the question which games could we consider flawless.
Jools :
1. Grim Fandango
2. Thief: The Dark Project
3. Patrician III
4. Sid Meier's Colonization - not really, the reliance on micromanagement without any help from the interface is a major flaw in my book. Very good game otherwise.
And adding:
5. Master of Orion 1 - this one is a really flawless one imo - elegant design, great replayability, AI that can (almost) play the game. The sequel did some things better but also had significant flaws.
Some others, which while not flawless, come pretty near:
1. The Longest Journey
2. Thief: The Metal Age
3. Half-Life
4. Corsairs (by Microids)
5. Sid Meier's Pirates! (2005 remake) - is this a joke ? If so, then a stupid one.
6. Hitman 2: Silent Assassin
7. Splinter Cell: Chaos Theory
8. 7 Kingdoms (1998)
9. Homeworld
Funny, but not a single RPG. Not on purpose, I just can't think of such an RPG.