I agree the Charlotte area might fulfill a lot of what’s on his wish list. I also agree that while it’s a reach, if he likes it he should go ahead and apply.
You’re right that if the OP enrolls in a NC CC, he will have a better chance at getting into UNCC as a transfer.