I was going to mention Sim City 3000 in there too, except there was no console version :lol:
Ugh...EA pulled the patches for it by the time I played it, and entire layers of graphics were just missing. Totally unplayable.
But like Nightfire-it looked fantastic for the time, and was pretty cutting edge gameplay. Not sure if it would hold up now, but for 2002 it was kick ass. But the PC version, that should have been better, completely cut out the driving sections (which were actually cool), and managed to wreck the FPS sections too. Can't remember the details, but there was just some completely broken stuff, sections of the game not triggering, enemies not doing the right thing, etc. Just an unplayable disaster.
(Weird, I just looked and Gearbox ported the Eurocom original to PC...what the heck? I thought Gearbox was supposed to be decent!)