Unless you think 90-100+ in the summer is nice, then no, North Hollywood does not have nice weather. Everywhere in the valley has horrible weather (excluding the coastal area). The rest of the LA area is generally pretty nice weatherwise though until you start getting further east. Pretty much anywhere that is affordable is really hot in the summer.
North Hollywood is pretty crappy in general, look at Burbank/Glendale area, maybe Pasadena. I would look at West LA, Santa Monica, Hollywood Hills personally, but that is only because I HATE hot weather, you are gonna have a crappy commute if you work in the valley but don't live there.
Houston was pretty unimpressive when I was there on business about 5 years ago. Cheap though.
I guess its just a matter of personal preference. Anywhere you go here in the US there is always a down side in nature. Up north they've got snow storm or whatever which is basically the same in the NW and NE corner. In the West, they've got earthquake. Down South is hurricane. Plains have tornados. "Lesser of two evils".
Cost of living, job opportunities, school system, etc. are what makes the difference.