Ah, got it (thanks also to Manfred PMing me).
I thought you said you didn't want the inconvenience and cost of an interchangeable lens camera?

Also, the 18-55's minimum focus distance is 25cm. You wanna get closer, budget for a macro lens. Bigger sensors mean bigger lenses, and bigger minimum focus distances.
The only thing about the Sony Alpha SLTs is that you need to know you'll be comfortable with an EVF (electronic viewfinder), rather than OVF (optical viewfinder)--think videocamera eyepiece, rather than SLR eyepiece. And you should check that the lens system will cover all your needs (both present and future). The selection of lenses is smaller than Canikon, and lower-cost/midrange lenses
may be fewer; and as a relatively less popular system, the used market is smaller. The high-end Sony glass, otoh, is Zeiss.
It's also new enough that it has
an ISO-compatible hotshoe, which is good for the off-camera flash stuff, although getting TTL-capable triggering is unlikely. Much better, though, than the old Sony/Minolta non-ISO-compatible hotshoe.