I still have my family of Syquest drives from the big 200MB 5.25" drives to the 270MB 3.5" drives. They still work great! No data loss yet. My units range from 15-20 years old. My original 44MB drive went bad because I left the cartridge in the drive too long (years!), so I guess the head got stuck or something. Amazingly, the cartridge still worked though! (when I used it on a working drive)
Unfortunately, the EZ135 and Flyer 230 drives were not that well built, so those tend to have problems like flying drive heads. I don't know what's worse - flying drive heads or Iomega's click of death. (I still avoid Iomega products like a plague. Yes, I hold a grudge.
Stick with the legacy drives, and you generally won't have a problem. Syquest Legacy drives are the 44, 88, 200MB 5.25" drives and the 105, 270MB 3.5" drives.