If size is a concern to you, Go for Prosumer PnS like Canon G11, Panasonic LX3 and attach raynox adapter lens to it. Good results.
DSLR quality, will come from DSLR and EVIL cameras only. And if doing macro, you will end up with quite a big package even with EVIL cameras (lens will be much longer than PnS). No way you can get the portability of a PnS.
Cannot have the cake and eat it la. Something's got to give.