Interesting question as the games are all from slightly different technology eras.
For me, the order is Cyclone, Hurricane then Comet. I had a Hurricane many years ago and traded it off. I just picked Cyclone a few weeks back and actually enjoy it more than I did Hurricane.
I played Cyclone a ton in high school so I suppose it has the nostalgia factor going for it. Hurricane was the one game in my line up that was always a quick play that never required too much "thinking" to enjoy. Cyclone is very similar in that regard (no multiball, no modes per se) but I think the Williams team did their best work with the theme on Cyclone overall. I'd take add Hurricane back in to my line up in a heartbeat -- if I had space.