You asked for my opinion so I gave it.
We took a few long range camping trips as you described with 2 daughter's and a son. We learned taking the camper on a 2 week vacation was an option, not a requirement. It's not always the best choice for everyone or every trip. We started limiting the camper to Hill Country and beaches, keeping it under 400 miles.
You said you would love to take the kid's to CO but it is too far to drag the camper. I agree. We live south of Houston and I would not load up the family and go that far with the camper. We drove there once without the camper to realize that wasn't very much fun either. So I offered you our solution. We Flew after that. We flew to places like NYC, Outer Banks, Acapulco, Toronto, The Bahamas, ect. as well. This gave the kid's opportunities to discover places out of camper range.
Not pushing a cruise but it is a family vacation. The kids always wanted to cruise. They had a blast every time and so did the wife. The only decision to make is what ship to get on and what excursions to do. The rest is taken care of.