Yes, HD speed is very significant, provided your IDE interface can keep up.
On an A1200, using the internal port, HD speed is irrelevant. On modern hardware you certainly feel the difference when using a fast drive.
Incidentally, the gap between SCSI and IDE is also much smaller on modern hardware. In fact, you need a really pressing reason to choose SCSI these days, as IDE drives and interfaces are pretty fast.
