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.
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.
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.