I came across this site after I burn myself to a nice painful crisp after only an hour on the beach in Hyannis, Cape Cod.
I tried most of the remedies listed here; vinegar, Vitamin 'E' oil, aloe vera, tea bags, 'Preparation H'.
But, after trying that last one, I finally found THE BEST REMEDY for SUNBURN.
'CVS Hemmorrhoidal Cooling Gel with Vitamin E and Aloe Vera'.
Clear, non-greasy, non-staining formula takes away the pain immediately, reduces the swelling and redness, and guarantees a good night sleep after acquiring a sunburn.
Of course, any other brand will do just fine (Brooks, Walgreens, other), and, most importantly, what worked for me, may not work for you.
It all depends.
But, I finally have my end-all-be-all for sunburn!