Anecdotally I can confirm there's been a few 40% years in the past decade, but it really is a gamble, and because of survivorship bias it's easy to only hear about the ones that gained and not the ones that lost.
I picked some winners, like Microsoft / Google, both up 150%, but they're tiny fraction of my total portfolio, so hardly returned anything all counted up. I did 170% at one point with Tesla too, but didn't sell at the peak. So ended up with 4.4%p.a. over 5 years.
Save to say I don't stock pick anymore and just buy VTI (kinda like VOO) and some VT.
But for someone who is 20something and begins placing $€200 per month in SP500 (preferably somewhere with the lowest possible fees), and does so every month for all the years he/she works, then there is a very nice surprise waiting for them (and their kids) later in life.
Keep in mind, investment funds don't die like our pensions, they are transferred 'down'. So even if someone has e.g. 200k when they have kids, by the time those kids turn 21, that 200k would have turned to 0-7yo 200k->400k, 7-14yo 400k->800k, 14-21yo 800k->1600k. It needs discipline and consistency though.
I'm under no illusion that this will continue going forward.