As an NC native living in Houston, I'm going to chime in with my two cents. Raleigh and the surrounding areas are great if you subscribe to the "white picket fence, 2 kids, dog, etc." line of thinking...and if you aren't really a working class person. If you -are- a working class person, Raleigh isn't really that great of a place. I worked at WakeMed and on my income, living in-city wasn't an option, unless I wanted to live at Pines of Ashton. Somehow, I value my safety a "bit" more than that. So that left me with the option of living outside the city - the Cleveland School area, to be exact. Traffic is a NIGHTMARE out there come morning and evening commutes (a 5 mile trip with point A being on the same road as point B should NOT take almost an hour) and it's not all that great other times. Traffic going into Raleigh to work is ok if you work at an off peak time. If you work a 9-to-5 job, pack a snack because you WILL be sitting in traffic for a while. Also, coming into the city from the east or south-east, forget about trying to find alternate routes because they are all jammed as well. Crime in Raleigh and the surrounding areas...well, let's just say there's a lot more going on than what is talked about on WRAL and the News and Observer. People in the area tend to look at things through rose-colored glasses and ignore the things lurking just below the surface. Shooting, stabbings, beatings, robberies, etc. happen - and just because they may not always be reported doesn't mean they cease to exist. As for Raleigh's "nightlife", it may be growing and if it is, good enough, but for people who want more than bars or nightclubs, good luck. I lived there for most of my 27 years and I was never really impressed with Raleigh's city-life. It was just too stuffy and...classist in a way. If you weren't one of the "upper crust", you were ignored (at best) or looked upon as scum.
Now, living in Houston these last several months has been a complete joy. By and large, the people in this area are MUCH nicer than the people in Raleigh. Traffic on 610 and 288 is much better and flows much of the time, much better than Raleigh traffic - not to mention the highways themselves are in better shape. It's also nice to be able to live IN the city AND feel safe. And yes, I DO feel much safer here in Houston than I ever did in Raleigh. Yes, crime happens here, but really in much more defined areas, unlike Raleigh, so it's easier to avoid the "rougher" neighborhoods. Race relations and diversity are so much better here - it really makes Raleigh look pitiful in comparison. Houston's Metro system and rail system are great compared to the "City Kitty" - makes it so much easier to get around the entire city and if you want to bike, why, that's easier too. Houston does have a good amount of green - although if you observe Houston from the freeways, you won't see a lot of it. If you go into the city, though, you can't help but see it. And, to be honest, Houston is a much more beautiful city than Raleigh. Oh, and the nightlife? Well, there's always something cool going on. It's hard to get bored in Houston.
As far as the temperature difference between the two - yes it's hot in both places during the summer. However, for the last two years, Raleigh has been 5 to 10 degrees warmer than Houston for much of the summer according to daily checks at TWC. At least Houston has the breeze to help make things more manageable, unlike Raleigh. Winters here in Houston are just great. It gets cold, but not bone-chillingly cold like it does in Raleigh and the lack of ice/snow is wonderful because that means you don't have to deal with the crazy-idiot drivers than appear in and around the Raleigh area at even the mere mention of a flurry. The governor says stay off the roads and the people say "no, let's go sight-see!"
Sure, there are a few things I miss about NC (Duke's mayo, for one!), but it's not enough to ever make me move back there to live. Visit, sure. NC is a good place to visit. But for someone who is blue-collar and not into the "white picket fence" deal, Houston's a better place to live.