I personally have two 36gig and some 9gig Segate cheetah SCSI drives hooked up to my Flyer and they work just great the other nice thing is you dont need to "short stroke" them as there fast enough to use the entire 36gig in high quality mode. I have even tried an 80gig SCSI that I am using in my PC at the moment and that also worked.
The 80/68 to 50 pin adapters are easy to find on ebay and are cheep (around $8 each).
Your right about the SCSI to IDE adapters its not cost effective to do as they are around $70 each and you have to have one for each drive so that can get far more costly then just getting several 36gig or larger SCSI drives. A 36gig drive will give you more than 3hrs of video in HQ mode