Wrightsville is a great area. I lived on Oak Island (about 30 miles south by car) for 8 years and in Wilmington for 2. I love the area and would still be there if the winters were warmer.
Dunno what kind of vacation you're after, with kids or without... as TB said- there's plenty to do in Wrightsville. Carolina Beach is a bit more laid back. Masonborough Island is where the locals hang out- you'll need a boat to get to it. The high rent district is just north of Wrightsville- Figure Eight Island. If you want a place very laid back and away from crowds, check out Holden Beach- about 35 miles south of Wrightsville.