With my cheap Irish skin, I'm sure to get a severe sunburn once a year. I've had one so bad it started to bleed; that one almost stopped me from going to highschool prom.
I had tried Noxzema moisturizing gel, cold shower, hot tub, and several other anecdotal remedies for sunburns, but nothing worked - for about five days following a sunburn I was basically handicapped.
A year or two after the big one I tried the [fake] aloe vera and it finally seemed like something worked. Ever since then, I'll use roughly a bottle a day of the stuff following an intense burn. This has reduced the discomfort to the level that the average Joe expresses as in "Ahh, extra sensitive right now" not "Can't put on clothes right now"