I can't speak to reliability with SCSI tape drives vs. IDE tape drives, since I've only worked with a couple (OnStream SCSI) but my experience with hard drives tells me that SCSIs are more reliable than IDEs.
That being said, you have to remember that the advantage of SCSI vs IDE are the capabilities of the SCSI bus and devices attached (Bus Disconnect, Tag Command Queueing, etc), plus the number of devices that can be attached to the bus give SCSI a distinct advantage in most configurations.
As always, IMHO
alzan