A couple years ago I built a computer with SCSI components.... to make a long story short, I wish I would have gone ATA for one major reason: upgradeability.
This may seem a bit backward, but hear me out... At the time I built, I went with SCSI primarily because I wanted a good CD-burner (and SCSI was "cool"😉. ATA burners are much more reliable now. Now, I am sort of locked into SCSI. I would like to be able to swap components and make a new computer, but with SCSI, my options are more limited, not to mention more expensive. For instance, I would like to upgrade my hard-drive and give my old one to my parents... NOT... their computer is ATA, along with a mojority of my friends computers.
Today, as Modus said, ATA100/66 or even 33 serves everything except servers perfectly fine. ATA is cheaper, almost the same performance, and keeps your upgrade options more open (in my opinion).
This was not always the case, SCSI used to be the undisputed champ in performance. But, with the rate of advancement in computers today, I think ATA is a good choice.
One last thought.. I am not well versed, but I have heard some tidbits on serial ATA. I would consider holding out if you can until this new standard comes out. I am planning on hanging onto my SCSI system at least until then.