The best one I have ever tried, bar none (probably even better than the Japanese ones) is the LaRoche Posay Anthelios Invisible Fluid SPF50 www.laroche-posay.co.uk/en_GB/anthelios-uvmune-400-invisible-fluid-spf50-sun-cream-50ml/LRPUK-164.html - but it costs a fortune, something like £14-18 for 50 ml!
Our favourite (but still reasonably priced) ones are:
Vichy Melting Gel SPF50
www.vichy.co.uk/en_GB/capital-soleil-melting-milk-gel-spf-50/VICUK-088.html
Not the easiest to find, but you can find it for ca. £20 (for 200ml) on Amazon; this French store sells it for £15 including an aftersun, and ships to the UK
www.cocooncenter.co.uk/vichy-ultra-melting-milk-gel-spf-50-200ml-soothing-after-sun-milk-100ml-free/30811.html?gclid=CjwKCAjw682TBhATEiwA9crl35hj6guGne507Je1rdjZAblPzhjDcWngLgutQadd1XPLm1b0nqoawhoC3SkQAvD_BwE
It is not as light on the skin as the crazy expensive one, but it is good and seems to resist well to water (within reason - we always reapply after 2-3 hours if we spend the day at the beach).
The Altruist SPF 50 is also very good, easy to find on Amazon and cheaper.
The whole family also likes Japanese sunscreens (Nivea Japan - very different from the Nivea sunscreens sold in the West, Biore Watery Essence, Biore Watery Gel, Anessa perfect milk, Aness perfect gel). In the past we have bought these from yesstyle and stylevana but they are more expensive. Basically we would buy a few of these to use during spring in the city, but only use the Vichy and the Altruist for things like beach vacations, where we seem to consume more litres of sunscreen than of beer...
A few more comments:
no sunscreen will work perfectly on all skin types, so there will always be negative reviews on every product.
It is possible to get very good and cheap protection from the likes of Aldi Lidl etc. When you pay more, you are not really paying to have a better protection, you are paying more for something which feels lighter and nicer on the skin (we tried the Lidl ones and didn't like them)
many people apply too little sunscreen, don't let it dry on their skin, maybe immediately put on clothes which rub some of it off and maybe dive before the sunscreen has been absorbed. In many cases, when people post negative reviews because they got sunburnt it's due to a combination of these factors rather than to the product being faulty.