erm, right, wow this thread fills up fast!
a3/4k machines are limited to 128MB for the cpu slot.
i'm not sure if there is a zorro3 limit of 1.76GB or 2GB or if its the full fat 4GB (minus system board devices) i could look it up, but its friday and i'm actively being lazy.
the A1200 is able to take more than 128Mb as it doesn't have to map out xGB for zorro3 space, so all the 4Gb memory space above the standard amiga devices area is free for use. hence you can have 256Mb ram on a blizzard030.
same for the A500/600/CD32 when fitted with relevent accelerators - but these only had one simm slot so only 128Mb is possible.
not sure about the A2000. as that doesn't have to worry about zorro3 space. but then you just have to get over the possible issue that the memory controller logic on the accelerator might not understand more than 128Mb.
so some 060 based A2000 accelerator with standard 72pin simm slots would be your best bet.
in theory, each zorro3 slot can take up to 512Mb address space (possible ram). i've been thinking on brewing a zorro3-to-DDR1 dimm card. obviously it'll be no faster than whatever Zorro3 can drive it at, but its the capacity that would be nice. however, someone has already experimented with 3 DKB128 cards, and a fully loaded accelerator giving 512Mb ram. but it seems there was a bug found in exec which limits addressable _system memory_ to 384Mb. not saying that you can't have anything else in there too eating up address space, just seems the system can't understand more actual RAM than that.
--edit--
you may find that designers/manfacturers may have saved money/time/PCB complexity by only running 25/26/27 address lines to the memory controller making the max addressable ram for that board 32/64/128Mb ram. hence why apollo's for 1200's may max out at 32/64Mb.