How do families plan an affordable trip without making the schedule exhausting?

Question

I am planning a five-day trip for two adults and two children. The cheapest options often involve long transfers or inconvenient hotel locations, while packed itineraries make everyone tired. I need a method for balancing cost, comfort, and a realistic daily schedule.