New family car is coming up!

We need a new family carriage. Our Ford Windstar is now almost 12 years old (without major infirmities!!!) and we are of course a bit spoiled by the space available. Our family is however two split. The dad would like to have a Q7 – due to its appearance and of course AUDI (but probably not included because of €) and the mom is now on the track to the XC90 (Only used ones). Is the XC 90 really as comfortable as it looks at first glance? The Q7 seems to me to be a bit more economical from the space offer. Would I look forward to answers. Also what we should pay attention to when buying.