Well.
Sincerely, soccer games are fun, and nowadays it's easier than ever play them when PES/Winning Eleven/eFootball gone free to play and while a first messy launch party, it will possibly improve with the time.
In N64 you have International Super Star Soccer 64 (Winning Eleven) that is still highly regarded nowadays for people that weren't fans of sports games at all.
The hockey games are fun because they are arguably similar to the soccer games, and you have a few.
The Baseball games are fine but they are slow and harder to play, so don't expect something that will make you feel rewarded unlike you know what are you doing.
Basketball is fine, you have NBAjam that don't take itself seriously, or more common ones like NBA in the zone that is fun in shorts bursts.
From there.
If you want something that feels something else than a common sports games, the answer is still Konami's own "International Track and Field 2000" and "Nagano Winter Olympics 98" with their gameplay mostly based on minigames and button mashing.
