I can (& have) slept in my Galaxy, it’s like a van with the seats out. Finding a good one means the TDi engine & manual box, but decent ones are rare these days. They have a few common niggles, all cheap to fix. But as a bus for kid hauling, bike hauling, (caravan hauling in our case), they are simply great. Mines on 130k now & just gets on with it.
£2k is a tricky price point, you could end up with something shagged or a right bargain. In general, look for lower spec, petrol engines as there is less to go wrong. Having had one, a T2 or T3 spec 1.6 or 1.8 Toyota Verso would be one I’d look for.
The problem with SUV / MPV type vehicles is the use they get. Kids jumping in/out, stop/start school/shopping run type stuff really leaves its mark.
If it were my £2k I’d look at a large hatch or estate. Again, petrol engine, lower spec. It will do everything an MPV will do but your more likely to get something that has been looked after. 80k of motorway mikes is preferable to 40k of town duties.