"Stack" tends to refer to tools (i.e. "the tech stack"), rather than roles/titles which is what you've outlined above.
Interesting that you say you've been victim to "just learning any languages/etc. that [came your way]", because that probably isn't a terrible way to get a feel for what you do/don't enjoy, so although it might feel like time has been wasted on that, you're probably better off for it really.
It can be helpful to have a rough idea of what different roles are out there, and then using those to focus what you learn of course. Although unfortunately some roles, like "full stack developer" mean entirely different things to different people.
If you're interested in seeing actual tech stacks that people use in the real world, Stack Share is a pretty good place to look.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.