There's much less foam in low alcohol beers, so it's not just the alcohol content (unless that affect it directly in some way I don't know about).
But I am more of a Pilsener guy, and there are a few good alcohol free Pils which I am convinced would taste like the "real deal" with the added taste of alcohol.
The thing that makes beer foam stay there is the protein content. Yeast contributes some, but it's also in the grain. The foam should be less different if you compared something filtered like Heineken and Heineken 0.0.
this is not a good expectation. Yeast will consume all available sugar till the alcohol %age gets too high for them (depends on the yeast but even the hardiest cultured strains poop out at around 16%. But they can only consume what sugar is in there, so if you ferment starting with something with little sugar, it will not arrive at a high alcohol level.
Our ancestors did not have access to lots of sugar, even their fruits (therefore juices) were less sweet.
to your point about insanely sweet starter, wine grapes are also insanely sweet, so sweet we don't want to eat them. Table grapes like you buy at the grocery, sweet as they are, are much less sweet than wine grapes. So, starting from the ultra sweet grapejuice, average wine gets to 12% alcohol.
I think it depends on the style. For hoppy ales Athletic Brewing in the US makes really good beers, you can hardly tell there is no alcohol. As far as I heard they don't really remove alcohol, but I don't know how they brew it. (Might be a secret process.)
Regarding German beers, this is also what I find near me now, and they are all decent, but you can definitely tell they don't have alcohol.
- Toast 300g sliced [rye] bread to near burning
- Boil 3 liters of water, turn off, insert/soak bread
- Let sit for 6 hours
- Add 150g sugar, 6g instant yeast
- Let sit for 18 hours
- Remove bread, strain out extra liquid from it. Birds love it, once it dries out.
- Bottle up the liquid (leave headspace for gassing), and occasionally burp it.
- Wait. Longer bottling period = smoother, less carbonated, more alcohol, less sweet. ~12 hours, but this is very subjective.
- Chill + drink. Take the lid off very carefully, aim away from eyes.
In Finland, a home-made small beer (kotikalja) remains a popular drink in the countryside. The alcohol content is around 1%. It’s a sweet brown mush that you can make in one day at home using rye malt sold in every grocery store. Here’s a video:
There's a Tibetan/Bhutanese/north Indian barley version of this too, known as chhang.
It's not up to modern standards for "alcohol free" beecs, but it works if you're just aiming to hydrate while avoiding pathogens in your water supply.
How did they brew such small beers? Nowadays the non-alcoholic beers (basically 0.5%) are mostly made by removing alcohol after brewing, which greatly affects the taste. I think it's a highly desirable skill to be able to brew good small beers. (Or maybe those beers were just not very good by today's standards.)