Glad to try to help, but I really don’t want to give specific advice wrt the choices you are considering, since this is such a huge decision. I’ve even been reluctant to advise friends we have known for years who have moved into the area, because, in the final analysis, only the people involved really know what will best work for them.
That said, I think spending time with your realtor in all of your areas of interest, as well as touring the CC’s should give you a great deal of insight, and will help you find exactly what you’re looking for.
Edit: Just a couple of other thoughts.
You have some very valid concerns and questions, and your realtor should be able to answer each and every question you have, or be able to refer you to someone who can. If not, I would seriously consider interviewing other realtors who specialize in RSF, because a good agent will get you all of the answers you need in order to make your decision.
