I’m going to give honorable mention to Buck Bumble on the N64.
I remember basically nothing about the game, or even if it was any good, but I rented it once at blockbuster and like 2 decades later the theme song still pops into my head once in a while.