Fayetteville isn't really the T"riangle", so you might get better luck posting one level up in the General NC forum (I usually see a lot of Fayetteville threads there).
Bottom line, it's a big military town, and those aren't generally known as being confused with Beverly Hills or Martha's Vineyard. However, every area has its nice parts (and it's "perfectly fine" parts), including Fayetteville. It has the biggest mall in Central NC and pleny of children, so there have to be lots of nice area for families. I would search the General NC board for posts about Fayetteville and probably some of your questions will be answered, and you can ask clarifications on others.
Here is a snapshot of the town with some basic data.