Xbox was king in this department, many overhyped titles like Sudeki, Brute Force, Blinx, Breakdown, Amped, Full Spectrum Warrior, Grabbed by the Ghoulies, Gunvalkyrie, Toejam & Earl III, MechAssault, Steel Battalion, Otogi, among other that no one remembers this day.
Pac-Man Vs.was one of Nintendo's biggest busts in GCN days as it hyped as one of the biggest bets to promote it's GCN-GBA cable connection. Few actually play it. Final Fantasy: Crystal Chronicles was another one. It was the first and only Square Enix title for GCN after the reconciliation and had somewhat of an expectation due to this context, it crashed and burned.
But here's more:
The Getaway
007's EA games
Auto Modellista
Aggressive Inline
Dawn of Mana
Shadow of Rome
Rise to Honor
Rogue Galaxy
Dark Cloud 1
Jak series
Red Faction
Resident Evil 0
Winback
Turok series
PS2's Shinobi
Metal Arms: Glitch in the System
Manhunt
Dead to Rights
Enter the Matrix
The Suffering