You could also use a spinner for Omega Race and Arkanoid, as well as Tempest. Also for many driving games like Pole Position and Iron Man Stewart's Off Road, in lieu of a steering wheel; it's not the same, but it's better than a mouse or joystick.
I think it was Discs of Tron that used the push-pull spinner. Tron uses a spinner along with a trigger joystick. It's really tough to play even with a spinner using a regular joystick like a Happ Super.
Personally, I put a lot of effort into building my own spinner, and I even bought an Oscar MAME knob for it. Had a great time doing it and it works great, but I really don't use it much! If you like driving games and don't envision building/buying wheel controls, maybe you'd use the spinner. Otherwise, if you're not a Tempest addict, maybe you could do without. Probably ought to come down to budget issues rather than space, since it shouldn't take much space on a two player CP.
That's just my 2 cents. I'm sure you'll hear more examples of spinner games from others...