Lived in Raleigh for awhile, hated it. I'm not a redneck by any stretch of the imagination, but unless you like 30-something yuppie idiots with 2.5 kids who drive like damn fools and have a huge mortgage on a suburban home you will not like Raleigh. Although the many thousands of illegal hispanic immigrants don't seem to mind that much, actually. Definitely a clash of cultures here--white, black and hispanic all going in different directions. My single friends hate Raleigh, it's a working family town.
Whatever magazine your wife read must be out of date. The triangle area was damn decent back around 1990, but has since been utterly spoiled by mass migration of shitbags from the north. North Carolina is fast becoming the New Jersey of the south (literally--people from Jersey migrate here in long convoys) and I see no way that that trend will stop anytime soon. It will be like Atlanta in a few more years, but I'll have moved completely out of the state by then, probably. Did I mention the anti-gun governor and the no-prize US Senator John "I wannabe JFK" Edwards? Of course, Helms is here, too, but he's sort of a sad, old caricature and should have retired two decades ago. Everyone accuses Helms of racism as if they had enough brains or historical context to really know what the hell they're even talking about.
If you do move to NC, to yourself a big, fat favor and don't move to Wake, Durham or Orange Counties where the taxes are high and/or the anti-gun liberals run the show. Durham is a pit, avoid it at all costs. Charlotte is probably the same way, but I don't know. Many of the other counties seem to have the opposite problem--overly religious, uneducated hicks and trailer trash who enjoy (for example) dog fighting. Take your pick. Neither is my cup of tea. Asheville has some nice aspects to it, so do the coastal areas, but I never seem to be able to find the right mixture here. Maybe it's just me.
The weather is decent as long as you can stand the hot, hot summers. Class III is easily done in most counties if you get to know the right people--make a donation to the sheriff's reelection campaign, for example. The old south (old boy system, that is) is very much in operation. The pistol permit thing is fucked up, but it sort of works--keeps the guns out of the hands of the blacks, dontchaknow. That has to be what it was meant for, the way it was setup.