I think a lot of it depends on where you want to go (i.e. size of school). If you want to attend a bigger school (Clemson, USC, C of C) who recruits at a regional or national level, then it might help for you to seek out the top club in your area. If you live in a smaller town, it might mean driving to play for CESA, the Bridge or one of the Charlotte clubs.
If you are looking to play for a smaller school (Limestone, Erskine, etc), then you might be able to get away with playing for your local club no matter how good they are.
The more important thing is where you live b/c that determines whether or not you will qualify for in-state tuition and thus how much of the scholarship budget the program will have to use to obtain your services. For instance, if you are an above average player but not a superstar who lives in Charlotte and want to attend a S.C. school--- would it make sense to move to Rock Hill a year before you go to college to establish in-state residency?
Even though they are both "1 scholarship", in general 1 in-state scholarship is less expensive to a program than 1 out-of-state scholarship. That is unless of course, the institution has an out-of-state fee waiver for scholarship recipiants.
