First off,
I have optics on my duty pistol and my concealed. Trijicon and the Holosun 507 are the current best ones in my experience for duty or defensive use. I'm not a big fan of mailbox optics but for entirely personally subjective reasons.
Secondly, using an MRDS on a pistol won't make you magically worse at irons. It's a whole new skill you have to train, to find the dot quickly etc. What I've seen a lot of guys do is just slave the dot to their irons so it's essentially just assisted shooting. I can tell you after using a pistol dot on duty for a year, I wouldn't go back. Target acquisition and firing accuracy is insane once you're trained and experienced on using them. Batteries last five years for the optics I use, always on or shake awake.
Carrying concealed with an optic takes getting used to but like carrying concealed in general, it's a body composition thing. It will be more uncomfortable if you're fat. I'd recommend a sweat guard behind the optic on any concealed holster.
I'm going to stress that this doesn't magically replace irons shooting, it's just quicker acquisition. If my optic fucks up or the batteries die, I can still use the suppressor height irons on my duty gun like normal. If it happens on my carry gun, my LE G43x came with Ameriglo night sights that once again, let you shoot irons just fine. The only way you'll have issues is if you're one of those dumbasses that removes their pistol iron sights entirely.
Yes, the set ups get expensive quickly for quality gear, but that's always been true of firearms everything, don't let that intimidate you into thinking it's a cool guy only thing. Be Smart, do your research, and buy what compliments what you're trying to do. If you want a dot set up, get irons you can use in case of failure. Buy a reputable brand that isn't known for failures (Like Vortex MRDS and the glass falling out). Practice, practice, practice.