I don't know as much about living in Raleigh, although I've visited the city several times. My parents live in Chapel Hill (about a 30 minute drive away) and my sister went to middle school and high school there.
The Chapel Hill/Carrboro school district has been called the top rated public school system in the Southeast, and among the top 40 best districts in the US. The high schools in particular rate very highly for test scores, Advanced Placement, etc. This was my sister's experience and her friends there -- they all got into very good universities.
The Research Triangle Park area with the three major universities - Duke, UNC, and NC State means there is a pocket of very highly educated parents around the Triangle area (Chapel Hill, Raleigh, Durham) which I think is a big part of it. I don't know as much about the Raleigh and Durham schools however.
Carrboro and Chapel Hill have more of a liberal small town/university town feel. They are also much more left wing and progressive then the rest of the state. The politics of elected officials in the rest of the state are actually very right wing right now.
People in the south tend to be friendly and welcoming. Chapel Hill and Duke are a bit sports crazy - mostly at the college level. My sisters friends did track I think, but like I mentioned her school was very focused on academics.
I haven't visited Toronto, only Vancouver and Montreal - both Vancouver and Montreal are much more diverse and cosmopolitan than Raleigh, I'd say.
ETA: there is more international diversity right around the universities and Research Triangle park because of the student body.