Good topic for a thread, imho.
Titles with a lot of polish are the games that really show how slipshod most releases are.
A lot of highly polished titles have already been mentioned.
Stuff like LOZ:Twilight Princes and Ninja Gaiden.
I think gameplay difficulty is the hardest thing to get right consistently across the duration of a game. Technical and graphical polish is an easier target to achieve.
God of War is technically very polished, but the difficulty spike near the end, with the repitious tower climb, taint the whole game.
I think the bland later levels in Halo, with a lot of repeated corridors also takes the sheen of that game.
Gran Turismo 4 is also technically very polished, but there is no gameplay left if you've been with the series since the beginning. I only play it in 6 player network, where it is excellent fun.
Half Life 2 sticks out as a game that was all round excellent, but the Source Engine/Steam issues will have made a lot of people see things differently.
Recently I've been very impressed with Tekken on the PSP, that is the complete package. It is disappointing that such an excellent game should have sold so poorly. If you had told me 5 years ago that I would be playing a game graphically supperior to Tekken Tag on a handhold in wifi versus mode I would not have believed you. The wealth of content in that game is like a lover letter to fans of the series. When you think that the Xbox, GC, Wii, PS3 and Xbox360 all lack a beat'em up as good as Tekken on the PSP, it really makes you raise an eyebrow.
The game that wins the lack of polish prize has to be Tomb Raider AOD, 4 years of development, millions in costs and the result is a game broken in almost every way. How could Edios have spend so much money and Core so much time for so little result is really puzzling. This was mean't to be a flagship console exculsive for the PS2, a sequel to a blockbuster franchise. The fact that Ubisoft got a game as stunning as Prince of Persia to market in similar timeframe really hammers a nail in Core's coffin.
Of course Driver 3 and Enter the Matrix must run TR:AOD a close second and third for lack of polish versus development costs and time.