Just a note about Mingo Creek - the pool and clubhouse were under construction all spring/summer 2007. Definitely explains why no one was there over the summer. We now have a nice, new athletic center in the clubhouse and I think there were a few updates to the pool. Even so, I actually prefer the pool complex at Riverwood, which we have access to and it's jst 10 minutes down the road. The Mingo Creek pool is very basic - fine if you're just looking to do some laps - and there's a shallow area for the little ones. But Riverwood has more for the kids to do. All in all, the amenities (particularly, having access to all the Fred Smith communities) are very nice.
Mingo Creek is a pretty quiet neighborhood. We live in the townhome section and it's VERY quiet. We're one of a few homes with kids. Seems like most of the townhome occupants are young, single folks or young, married, no kids.
Commute: The commute from Mingo Creek to N Raleigh is very convenient. My husband actually works in RTP, and commutes via I-540. I don't travel during rush hour, but I can get to Falls of Neuse Rd during the day in about 15 minutes.
Crime Rates: statistics say that Knightdale's crime rate is about the same as the US average and the NC average. My personal experience is that I feel safe here, in the city and in the neighborhood.
Resale values: we just moved here about 8 months ago, so I'm not entirely sure. However, there is a new phase of townhomes being built right now - they will be exactly like ours (which was built in 2006) and will sell for about 10% more. I'm happy with that.
I have heard that real estate in this area will increase in value significantly in coming years due to the opening of I-540 which gives Knightdale easy access to Raleigh and RTP. Hopefully that will be true... it seems reasonable.
Schools: We homeschool, so I really haven't looked into the school situation at all. Perhaps someone with more info can chime in on this topic. Hodge Road Elementary (K-5; year round) is located at the entrance to the neighborhood. I have a friend who's kindergartener attends there and so far, they are pleased.
I'm not sure what sort of commute you're used to, but Lake Royale is OUT there... it would probably take you an hour to get to Falls of Neuse Rd. When we were looking for homes last spring, we were tempted by Lake Royale. It seems like a lovely place, but every time I mapped out the commute, I cringed.
Hope this helps some. Good luck with your search!