First, a few comments to compare my notes to others.
After using the Vista for 7 years (4y with one child and another 3 with 2nd) I would only consider a travel system personally. The mileage we got from ours was incredible. Yes, it did cost us all about £700 back in a day, but thats £100 per year.. not that much. Besides, with all the accessories, I probably had £1k system, which than sold for £300 total after we got the use we needed. We flew with the damn thing before covid at least 5-8 times and I can't recall a time when we weren't happy having it.
Sure - after we got a much smaller Yoyo when 1st child was older this was huge improvement on weight and size and it travelled with us everywhere.
Vista is a pram for out and about, everywhere and I do mean that. Yoyo - that's a small, very foldable option for town use. From what I gathered you're more in the country?
In fact, I reckon your choice of the buggy is as important as the car actually. If you want something to last 4 years, which is the time they go to nursery, think through your choices.
When it comes to the car seat that plugs into the travel system, we used it a lot with the Maxi Cosi seat. Think we used it more often than the carrycot which was bulky and when you just need to pop out with the kids and are in and out of the car it was great. Bear in mind, babies are not suppose to stay in them for more than 1-2 hours from memory - that is what the carry cot is for.
A comment about car getting messy - well, can't help it, but that's why I go leather - so much easier to keep it clean. To protect it from car seats, you can get a special protector - pretty neat, we got ours free with the seats.
Must haves:
Space - Enough space so I can drive comfortably, fit the kids in the back (when they're newborn as well as when they grow), and have enough boot space to be able to get the necessary bits in for short and long trips away.
Power - no diesels, needs enough power to not feel glacial (something around 200hp or more), automatic.
Tech - needs to support Carplay and have decent audio.
Nice to haves:
Power - something that's at least 250hp and AWD/4WD.
Tech - Memory seats as I'll be sharing the car with the wife and it makes life a lot easier (its almost a must-have this). Adaptive cruise control (I've gotten so used to it now that it'd be hard to not have it), reverse/360 cameras would be nice.
Space - a 7 seater might be nice for longer term but its absolutely no essential.
Comfortable ride with kids? what does it mean lol?
Consider a rear/forward facing seat options that can span across a baby to a toddler. This way, you could install and forget for 2-3 years and only move them to a kids seat when they are tall enough.
However, most seats like this are bulky and with a permanently installed base so even dropping seats at the back is a faff.
Looking at your spec, Id probably be picking between V90, XC60 (same wheelbase as V90 but smaller boot), Karoq or an Audi equivalent.
Most of VW group cars will have basic spec, so your extras you want will normally be factory options, so if you need 2nd hand, this may be hard to get. V90 even in basic spec was coming very well equipped - I loved mine, but the damn thing was drinking fuel like crazy. If you are ok to put up 20-25mpg you have some nice strong engines with tons of room.
If you want a factory order or be on a lookout for the spec you want - our neighbors have a Karoq and 2 daughters about 1y apart (3-4yo) and when I see how much they can pack in there I'm always impressed. They still got a roofbox though, but I reckon they just take too much

My pet hate about VW group cars is always the fact that by the time you spec up what you want, all the options push the price past a XC60/V90/X5 base spec which already includes them!
Ps. if you want more input ref Vista, ping me a message separately, don't want to flood OCUK with baby related stuff lol