If you go for more than 4Gb you will need Kickstart 3.1 ROMs, the SCSI device patches, the NSD patches and an updated FileSystem such as the free SFS.
4GB+ will work fine with 3.0 roms, you just need the updated filesystem!
I had 8.4GB in my 1200 using AmiFS. Eventually filled it up too!