I had always thought that the area as a whole was considered the "Triangle" with "Triad" being another name for it. I never even really thought of Highpoint as an actual city truth be told because it looks like a massive conglamerate of subdivisions and shopping centers of the sprawl variety (my parents, grand parents, aunt and uncle all live in Highpoint).
I do not think of the region as being "Red Neck" in any way. You are right that the populous is highly educated on average compared to most locals. I also think that the people are generally kind and very willing to help out in any way they can. If you want to see red neck, visit southern West Virginia (McDowell and Wyoming Counties are among the WORST).