For me this goes to Master of Orion 3.
The second game is legendary for how good it was. The 4th game is honestly not too bad. It is very playable and fun.
However the 3rd game is really bad. So back that most people just stopped playing it and went back to 2 or moved on to 4 when it came out...