Like in the Raleigh area, school districts are county wide. The assignments are done by home address. It is subject to redistricting, but it's not as confusing as Wake County can initially be. No year round options in the mix, and no capping out of home schools. You can check home schools for any CMS address here:
GeoPortal .
I can't speak to the health care, but Concord and Fort Mill are both well developed suburbs. I don't think you'd have to rule them out.