NHL Stanley Cup on the SNES is pretty bad
But the two worst Hockey games i have ever played are Great Hockey for the Sega Master System and Alex Dampier Pro Hockey '95 (aka World Hockey) for PC.
Alex Dampier is horrible, it doesn't even feel like Ice Hockey, the players drift around like they're on roller skates