I've had my S-Max now for 2.5 years and have tried every fuel permutation.
The engine is the Volvo B5245T2 unit [5-cyl 20-valve 220 bhp] unit similar to the Focus ST's unit.
To my mind there's no difference between supermarket brands & "known" brands, and indeed no difference between 95 RON and 98 RON.
By way of example I filled up at Auchan in Cherbourg this year & got a tank of 98 RON fuel at "only" £1.15/litre.
Drove to LM & back, a distance of 380 miles. I averaged just under 27 mpg with 3 pax onboard & a full-ish boot. Kept pretty close to the speed limit, so nothing to draining on the MPG.
Frankly I'd have expected more like 30 mpg under those conditions and reckon that 95 RON would have given me the same returns.
The only fuel my car doesn't like is Esso, it pinks like mad.
So my answer is that mebbe the Renault doesn't like Morrison's fuel, and will perform better with [almost] anything else.
As to the diesel question that's very simple. If you drive <12,000 miles a year you should not buy diesel. You'll never get your money back.
The slavish adherence to "must buy diesel" mantra is false in the UK.
I know people who have bought diesels in Jersey and wonder why they have problems with the Diesel Particulate Filter. The DPF needs constant speeds to work, something not possible on Jersey! They bought diesel because they holiday in France once a year!!!
Just remember that petrol emits CO2, which will affect the quality of your life, whereas diesel emits NOx, that will shorten your life.