Both IDE and SCSI can only directly handle 2^32 (or 4 billion) sectors, which is 2 terabytes (or 2,199,023,255,552 bytes).
Both IDE and SCSI are extensible, so they technically can talk to drives which are larger, but if the chips don't directly support the larger sizes, then the CPU must do all the work of preparing and sending commands which ask for sectors beyond the 32 bit boundary, which means it's possible but slower.
When it comes to the Amiga's IDE, the CPU already does all the work, so it wouldn't be any slower, but someone would have to update the IDE drivers.
I've personally run 2 TB drives on both the Amiga's IDE and on the CyberStorm PPC SCSI under NetBSD. I don't have any 3 TB drives yet, but when I get one I'll pop one in and see how it works.