Erin - Hopefully you've decided where to live in this area by now but just in case.These are all very different communities! If you are mainly looking for the nightlife you will want to get closer to downtown Raleigh. Wendell is a bedroom community with a classic walkable downtown with some shops and services. The local community is very involved and it's great for families. The Agave restaurant on third street in Wendell is offering mexican and american food as well as drinks and live music.
Knightdale will have more chain restaurants that should be open later at night.
I don't know much about Wilson but if you will probably be going against the traffic to get there from the Raleigh, Wendell area.