The question about boot speed is easy, any addin card that is capable of booting will make your system boot slower. A promise Ultra100 added a few seconds to my total boot time. SCSI shouldn't be any worse than that though.
IDE RAID is crap...it's software RAID (except Adapatec's card but it's like $400-500 for the controller) so you use even more CPU time than regular IDE.
Current Generation SCSI drives aren't that bad for heat/loudness, if you are going to get a 15,000rpm Cheetah X15 you might have some issues depending on your case fans/space...but beyond that you should be ok...older 10kRPM drives could cook your bacon for you,but new ones are no worse than IDE. an X15 is a bit loud, but not to bad.
SCSI is also a very effecient protocol; it very very low CPU, and also handles a high number of devices very effectively.
IDE RAID0 is dumb...access time for drives is the same as a single drive at best, but it increases transfer rate at the cost of CPU cycles. From what you're doing it doesn't sound like Xfer rate is the limiting factor. That's only in like Video editing or something like that...for a low cost Video editing workstation with spare CPU power IDE RAID0 might yeild some benefits....but that's about the only case.
A SCSI 10k RPM drive would yield you more benefits over all, it would have less transfer rate, much better seek time, and lower CPU time, and just over all SCSI goodness. Probably have an 8MB cache or something silly like that on the disk, give yourself like 128MB of Vcache (I'm sure you can afford 128MB of RAM right now if you are considering SCSI) and your disk performance will dominate a silly IDE RAID0 setup.
IDE RAID1 is a totally different story...that doesn't increase performance at all (in fact lowers a bit in every measure) but duplicates all your data, so if you have important data on your puter that might be a good idea.