I do feel you though. £7000 for Spain!? I'd go to Costa Rica, China, Indonesia, Australia or the US but thats just me!
School holidays, 6 people?
Yeah that's really unlikely to happen!
Have you taken a look of holiday prices to these places in school holidays?
Ie spent yesterday planning a holiday for me, dh and 20y dd. I teach so school holidays only. 2 weeks in Thailand, mainly B&B, in 4 star hotel (2 or 3 depending on if we move centre) - cheapest I've found for 3 people is £5-6k. That's with us sharing one room. I priced up Miami and a Caribbean island trip for same weeks and it was over £10k for same weeks, nothing fancy either and not AI. Costa Rica, Central America, Canada all around same numbers in summer holidays. And remember that's for 3 people, not 6.
Dh and I went a way at February, long haul, AI - just 2 of us and that was £5k, albeit a 5 star resort.
Me, dh and dd are going to New York for 5 nights in May half term. Room only, average hotel, all in one room. £2500 without any food or add ons, for 3 people. We are actually going there as I proved up Greek islands, Spanish resorts, Italy and south of France and they wanted more money for the same dates and duration, without AI. Again, for 3 people not 6.
Our holiday to Japan in 2019, in school holidays, was in excess of £10k for 3 people, without spending money and with RO accommodation.
I seriously doubt you'll find a long haul destination, even if not AI, for 6 people in school holidays for much lower. I was surprised how much the prices were coming in at for short haul destinations when I have been looking recently. Prices have really risen.