A pretty ordinary game I once played was aptly called The Last Resort. Only played it for ten minutes then put it back into its box where it stayed ever since. It just seemed pointless and boring. Perhaps if I gave it more of a chance it might have improved as it featured the voices of Cher, Christopher Reeve, James Belushi and Joe Perry (of Aerosmith) and was produced by Rober De Niro. Impressed by my memory? ;-)
Btw, could be abandonware now.
The worst game I've heard of but never actually played was Carmagedon. Points for running people over....? Tonz of fun.