I’m not seeing this OP as necessarily seeking a “prestigious” address. They may have mentioned these locations because that is all they’ve “heard about.” I’m getting from the OP that they desire a Catholic education for their four children (Grades 1-12). That can be done in SD. An Elementary Catholic education can be reasonable but Catholic HS comes with a price (which I think is worth it).
In any case, the OP has four young children to educate. This seems to me to be more important to him/her than housing considerations (which is secondary to where they will choose to join a parish and send their kids to school).