There is little to no benefit for very fast HD's, you may say an increase in load time but not in actually performance of games.
With he SCSI drives to you most likely need an adapter and like previously said, they are expensive.
At my work they have 146 Gig SCSI HD's that cost 750.00, Seagate Cheetahs. I wouldn't mind having one, but not for that price.