I suppose a forum section could work; I'd recommend it have an article or pinned topic with a breakdown of strategies and recommendations for dealing with non-divers, to quickly get people up to speed with common advice and options without having to sift through a dozen threads right off. And I suggest 'non-divers,' not with 'non-diving spouses,' because kids, friends, parents, in-laws, there are a range of possible extra baggage on your trip.
I am married with an elementary age daughter. My wife was certified many years ago, did maybe 30 total dives, drifted out of it, and hasn't dove since well before our kid was born. She was more the 'cruise ship excursion' valet operation boat diver type, not the how-many-dives-can-I-pack-into-this-trip type. On her land vacations with an old buddy, they don't really plan, they basically get a hotel with a balcony so they can sit, stare at the ocean, yak and occasionally go for a drive and saunter around some shops. I'd go mad with that trip plan. To me a vacation is an expensive, dearly priced rock I aim to squeeze all the blood (er, joy, that is...joy!) out of that I can. And that takes planning!
Now that I'm retired, economic realities (i.e.: a whole lot less money) will mean more focus on solo dive trips, but here's what's historically been done.
1.) Some of those 'dive trips disguised as a family vacation,' to Jupiter, FL (x2), Key Largo (x1), Morehead City, NC (x1), St. Croix (x1) and Curacao (x1). All 4 destinations offer a good range of drivable topside activities, plus we took her mother along to give my wife socialization and help with our daughter. I did carve out some time spent with the family.
You can either dive heavily a few days, then take some off, or do the '2 morning dives, back from lunch onward' approach.
An A.I. resort (e.g.: Sunscape Resort Curacao) or a hotel near restaurants (e.g.: in Christiansted, St. Croix) is helpful. Some of the southern A.I. resorts in Cozumel with dining ungrounds and short boat rides to the reef by on-site dive op.s should work for this.
2.) A cruise is the ultimate 'a little diving but mostly family vacation' option. Or maybe a Sandals Resort; they're noted for vacation divers and rather short dive times, from what I recall in trip reports, and the prices scared me off. They don't do kids, but the Beaches Resorts do.
3.) How clingy (er, sorry, companionate) is your spouse? Do they just need something to do (and is that as simple as reading in a hammock, or spending money shopping, or excursion tours?), or does this spouse insist on your bodily presence a large portion of the day? Some couples seem joined at the hip, and some touch base occasionally.
If lots of family time is a must, destinations frequented by cruise ships often offer a range of topside excursions.
4.) Non-diver children add a whole other level of complexity to trip planning. Younger minors may not be practical to leave alone. Even if you and your spouse dive, somebody's got to be available. A.I. resort with a good kids' club can be a real winner (our daughter loved Sunscape Resort Curacao). Good healthcare readily available is a plus, in case of middle ear infection, bronchitis, etc...
Then consider what categories one might address. The basic idea is diver-friendly, non-diver-friendly, and family (e.g.: got kids)-friendly.
1.) Solo-friendly locations - when you even dive solo part of the time (this is the opposite of what you asked about; hey, I like solo!).
2.) Traditional buddy diving destinations for divers.
3.) Dive destinations with a non-diving spouse.
4.) Dive destinations with a non-diving spouse and kids.
5.) Dive destinations for a diving couple with a non-diving kid (yes, they can swap out diving vs. babysitting, but locations with a kids' club or reputable baby sitter for hire would be a nice option).
Within a destination, location and operator matter. Is there an A.I. option? On grounds entertainment? When will you be back from the morning dives?
To address your original situation, Sunscape Resort Curacao rocked but wasn't cheap. I imagine one of those southern A.I. resorts in Cozumel would be good. Maybe Sunshine Suites or Comfort Suites as your base in Grand Cayman near 7 Mile Beach should be good. I hear good things about some places in Roatan (e.g.: Turquoise Bay Resort), but CocoView Resort (would love to go back!) could bore a non-diver over a week. Jupiter, Florida and Morehead City, NC offer beaches and topside things to do.