I'd also suggest you look at Playa del Carmen. Closer to the reefs of Cozumel than Cancun, lots of things to do, beautiful beaches, shopping, and affordable.
Depending on what your family likes to do to entertain themselves, Cozumel could be a good match too.
Regarding cost, you don't have to...