I enjoy Raleigh because it's a good deal warmer (15F warmer on average during Fall, Winter and Spring) than my previous homes in NY, and I hate snow. Unlike Shannow, I wanted to LEAVE Upstate NY because of the snow. I grew up in an area that got 120" of snow per year... Raleigh averages 7.5" per year.
My area is also a newly-developed upper-middle class neighborhood, with a bunch of stores and restaurants and such within a 5-minute drive. The convenience is great.
However, I find the road system where I live to suck balls. In NY, all of the stop lights were "smart lights," in which they could sense when a car is in a certain lane at the intersection, and change the lights when needed to make traffic flow more smoothly. The lights also communicated with each other to keep traffic flowing. If Raleigh had this technology installed, a 20-minute trip would only take about 12-14 minutes. The timing of the lights SUCKS.
Out of the places I've lived so far, I think Albany, NY is still my favorite. Colder and snowier than Raleigh, but I just felt more at ease and comfortable in the NY lifestyle.