In my experience working with Atari optic boards + mame, I have had hit and miss results. I have gotten some Tempest optics to work and some Tempest optic boards will NOT work. The optics in my original Crystal Castles trackball would NOT work with mame and I replaced them with optics laying around from an old Centipede.
Building a spinner housing is kinda tricky, I just use old Tempest spinners, if you can deal with all the real estate getting eaten up but how big the Tempest spinner is.
If I bought a spinner new, I'd go with the Turbo Twist 2 for certain. And Mikesarcade is not making the USB/PS2 trackball adaptors anymore and they don't seem to care about special ordering it either, so spinner solutions just got a bit trickier...