I belive the smallest IDE HDD I have is a IBM DTLA 2GB, and the biggest would probably be a Western Digital Caviar 120GB (that despite having been used in the worst conditions possible, refuses to quit working!).
Now for SCSI drives, that would be the 40mb Conner in my LC II... I love the deep humming noise that Conner drives make shortly before they spin the platters up.