It`s hard to point to one game, i was hooked at a very young age...
the first game that made me dream about it and made me go WOW was Black Tiger on the arcades... i had to stand on a chair to be able to play, the memory is so vivid even today, especially the music
but i guess that is not what you are asking about, because arcade games are pretty simplistic and while impressive they just come and go... if what you mean is a game that i was almost obsessed about and spent countless hours trying to figure it out that would be either settlers1 on the A500 or (and that is my pick) Frontier: Elite 2... I have spent to far to much time on that game and gave it quite a lot of focus during my early years
Black Tiger is still awesome. Mame is essential for those of us that played the arcades.