With 2 weeks anywhere in the NE, that leaves you a lot of options. A couple quick thoughts:
If you like the beach and you want to go that far, the Outer Banks of North Carolina are great. We really like the KOA there. We're trying to decide between there and Maine - one next summer, one the following summer.
Also, coming from Ottawa, if you want to take a more scenic route, check out the Adirondack Mountains in northern NY. That's our favorite place to go. Depending on your route, you can check out Lake Placid (recommend the KOA), Lake George (several spots to choose from, more of "touristy" area, or Old Forge in the southern part of the ADK's. We go a couple times a year to the Old Forge Camping Resort. There is a nice waterpark next door for the kids, and tons of other activities in the area.
I don't about anybody else, but I like to pass the winter months by spending some time reasearcing and planning the next big trip - have to have something camping related to do until the white stuff melts...
2005 F-150 FX4
2013 Rockwood Roo 23 IKSS