I have a Grand Scenic (had it since Jan) hi Fio, unfortunately I couldn't get hold of an automatic diesel, they;re like gold dust on the second hand market, so I've got a 2 litre petrol. I absolutely love it, it's 3 years old and is fab, I've got the privilege model, so it has keyless entry which is just fantastic when you're carrying a baby, no worrying about fishing around in your bag for your keys.
My only criticism is that it is VERY VERY thirsty, I get on average 26mpg. BUT it is an automatic (making it a heavier car) petrol.
If you can, try and get a diesel, much more frugal on fuel.
i have a grand scenic 1.5dci. i bought it from new 4 years ago and it has been fixed loads of times. had the aa out to start it twice, the battery had died and they wanted me to buy a new one - i said no and i wasn't paying under any circumstances and they could keep the car rather than pay-they paid in the end. didn't think i should fork out for this after only a year.
has had the turbo go twice-they tried to say it was my fault and i must have been putting 'dodgy fuel' in the car. said i had been going to the same garage for 5 years and never had any problems-turned out diesel was fine.
the only good thing is that the mpg is about 55 and the insurance group is low, it has a 5 star safety rating and you can switch off the passenger airbag. i can get 3 car seats in the back but it's a tight squeeze getting the seat belts on.
have had problems with the electrics too and airbag warnings etc. dp had a megane and had loads of welectric problems too-the window, drivers airbag etc.
so i would go for a toyota or a honda. the aa gut that came out said he had a toyota and his wife had the 7 seater toyota and wouldn't buy anything else. thought he was the person to ask!!