@Mike Williams In my opinion, and it's really just my opinion, people are getting carried away in Charlotte. I own a property in Ballantyne and if my renters were the easiest money in the world I would cash out now. We just bid on a SF and put in an offer 4k OVER ask and they still got a better offer (Ballantyne). We only did that because we knew that we could do some minor reno, refinance next year and get all our money out then keep it for a rental for a bit and get another pay day later. (BRRRR)
I think because you are planning to live there, this is tough. Normally, I'd say never let emotions get in the way. If you don't think it's worth what you are paying - don't pay it. If it were me, I'd probably call their bluff and say lower the price or I walk. This happened to my neighbor last year. They were selling their house and the new buyer agreed to 270 then the appraisal came back at 267 and they ended up lowering it for them. So, it can happen. Even in Charlotte!
Good luck!