I didn't say I was using it - I said I have one here... it's on a shelf with other bits waiting for me to hack the case. :hammer:
If I want to use SCSI/CD directly with my A1200 then at the moment I plug in a Squirrel and use a proper 50-way Centronics interfaced external cased drive (which has its own internal 240V mains supply). I don't want to draw 12-15W through the A1200 IDE header.
You can ignore the power used by the CF card, so you have 5-6W available through the header. My normal hard drive uses 0.7A (3.5W) which is just dandy, but I have an old Hitachi 1GB 2.5" hard drive that does work from the A1200 44-way, it uses 1.2A (6W) - that's the limit in my opinion. Whether you want to try 7.5W of CD is entirely up to you - I won't do it.
You might try tapping 5V from the floppy drive power header - it's largely idle in a hard drive or CF based system, and you probably won't be using floppy and CD at the same time very often.