All drives do fail, I am not going to argue that point. Whether or not SCSI drives fail faster than their IDE counterparts is also pointless for me to argue. I've owned a WD caviar 6 gig HD that lasted since 1998 and didn't fail until lightning struck the line right outside the house, and that will fry any system. I haven't owned a scsi system that long. My seagate cheatah has run reliably now for 1 1/2 years. All harddrives will fail eventually. Do IDE or SCSI last longer? I think that how long each drive lasts depends more on the quality of the drive than what kind of interface is used.
Which is faster? SCSI wins. At least some scsi. It may not be by much. Even against your 8mb cache WD (which seems to be the only IDE Hard drive even remotely in the same speed class as any scsi Hard drive) as the following article on Tom's Hardware guide will attest to.
http://www.tomshardware.com/storage/02q2/020415/index.html
Also, there is an article discussing the benefits of Serial ATA here
http://www.tomshardware.com/storage/02q3/020812/index.html
But this issue of speed, which scsi does in fact seem to win in most cases, leaves out the biggest benefit of scsi. As David points out, reduced CPU and RAM usage.
As far as doing research, yes, a search on google will get you some outdated and inaccurate information. The most up to date and accurate information on SCSI is available from
www.scsita.org
In the end the question of whether or not to go scsi comes down to money. Most people I know would go scsi if money were no object. But this is rarely the case. So you have to ask yourself if the extra $350 to $500 is worth what in some cases is only a 10%-25% increase in performance. Most people have to say no to scsi. When serial ATA has come to some maturaty and is in fact outperforming current IDE technology I may myself go with the Serial ATA box. But for now, I will enjoy the performance enhancements, however slight, of my scsi system.