I did a community pharmacy/ambulatory care residency. Also have an MBA. I considered going on to do a PGY2 in ambulatory care but decided against it. After residency, I was offered jobs in academia (ambulatory care clinic), district clinical coordinator for a retail chain, clinical director at a MTM company (after about 6 months of my current job), and the job I took post-residency where I still am: pharmacy manager at a pharmacy inside a community health center, focusing in HIV care. Also have some responsibility for being the "clinical contact" person for MTM for the area pharmacies. LOVE my job. Perfect fit for me.
The best advice I have about community residencies is that they are all different with different focuses. Mine focused on ambulatory care, specialty pharmacy, and teaching. Some are heavy on MTM/immunizations/compounding/ownership etc. If you are interested in working in an out-pt setting, check them out. But no two are alike - so do your homework!!! If you think you want to practice in a hospital or in-patient environment, run away from community residencies! There are some that have a decent component of transitional care from in to out-pt, but this is still very different than in-pt residencies.