"It's a pretty simple question seemingly but I haven't been able to come up with a good answer myself and put it into practice.. How to find model games for various openings, structures, variations, subvariations, endgames even to study as good examples of what to do in certain scenarios. Any input is appreciated. Cheers!"
With Scid and a database you can do all the above.
Buy books.
That's the point of (most) chess books: You pay money for the service that some author hand-picked model games about the topic of the book (and added his/her own commentary) and you don't have to do that yourself (which is the major alternative, which is why people are suggesting it here - they ARE answering your question).
To find instructive examples of a specific kind of opening or middlegame play is difficult. Even professional authors sometimes fail to provide the reader with adequate examples. Sometimes there is a good book exactly on the topic you want to study, but it's hard to know in advance that a book will be good.
For endgame play, it's easier. Theoretical endgames are mentioned in almost every book on the endgame (with the exception of a few books focusing either on a particular family of rare endgames or on non-theoretical endgame play). I've used "100 endgames you must know" by De la Villa and the older "Batsford Chess Endings". For non-theoretical endgame play (mixed with some endgame theory), I really like Keres's book on the endgame.