I have lived my whole life in NC and I prefer the Rolesville/Wake Forest area. From Rolesville you are not far from the 540 loop but the area is really peaceful and has the small town edge. You are only 10 minutes from Raleigh, so all major shopping can be gotten to easily. I could honestly care less for the Garner and Cary areas. I drove out to Garner a lot a few years ago while I was attending Wake tech and the traffic is horrible!!
Cary doesn't have any charm to me, so I don't go out there unless I have to. These are just my personal opinions though

I grew up in Zebulon, It's a nice small town, but I don't hear a lot of good about the school system now. They would attend the same high school with Wendell. A lot of people are using East Wake Academy charter school in those areas.
Knightdale is an okay town, and they do have a descent shopping area now. I live in Franklin county so I avoid all the school issues that Wake County faces. I think the commute from here may be a little more than you would want though. Check out Granite Fall subdivision in Rolesville, it may be worth your while. We have gone to a couple of swim parties at their club house there and I was very impressed.
http://www.granitefallscommunities.com/index.shtml
Just my 2 cents on all this of course. Good luck!