Please make some suggestions for sites, including what shop or charter operator to contact to book the dives. Will be bringing own gear, looking for recreational profiles.
If you come all the way to NC, and have your gear with you, I would be hard pressed to say, 'Dive our wonderful quarries.' when some really enjoyable wreck diving is just a few hours away. Several folks have mentioned Wilmington - easily accesible via I-40 from Raleigh (2 hrs). Suggest you contact Aquatic Safaris (
http://www.aquaticsafaris.com) who run frequent charters to many very good wreck sites, and have a very fast newer boat. An equally appealing alternative is the Beaufort / Morehead City area (2.5 hrs from Raleigh), with two operations in particular that you may want to contact - Discovery Diving (
http://www.discoverydiving.com) and Olympus (
Olympus Dive Center). Both are excellent operations. There are other good operators on the coast, and I don't mean to slight anyone, but these three provide a starting point.
Depending on how much time you have, wreck attractions include German U-boats (U-352 is probably the most accessible, but the U-701 and U-85 are very diveable as well), lots of WWII tanker / cargo ship wrecks (long list), and some artificial reefs (Hyde, Aeolus, Spar, etc.) that are simply enjoyable dives with regular shark sightings. You mention you are looking at recreational profiles, but if you decide to consider a deco dive or two, the USS Tarpon (foundered under tow) is worth a trip, as is the Yancey (reefed). Since you asked about specific sites, four of my personal favorites are the Naeco, the Normania, Esso Nashville and the Rosin Wreck. But, I suspect (and hope) 20 other locals will chime in with their list. It is truly a potpourri of outstanding wreck diving.
The in-shore wrecks have the advantage of shorter boat rides, but are shallower and have generally poorer visibility, and they are not my favorite sites. For the off-shore, deeper (90-130'), better viz wrecks, count on a 2 hour boat ride each way, so a 2-3 tank trip is an all day affair. Well worth it, however. We are proud of our coastal diving, but there are good days and bad days, so there is never a guarantee. But, if you are in the area long enough and have something of a dive 'window' chances are you can get in some good diving. Keep the Board posted as your plans eveolve and I will bet you can link up with some locals for a coastal charter or two.