I'm fine with multi-season series... the problem is they are usually made "as they go" without deeper consideration for the whole arc so when they run out of ideas and the "goldengoose" is still ripe they will squeeze it more till it dies... and at that point they usually cancel the show without tying out loose ends...
There was Expanse, it was planned (well, mostly) and had start-middle-end and it was brilliant (book wise, show was... guess what... canceled

)
I'm old and grumpy and "timewasted" on myepisodes says 5593 episodes, 284108 minutes totalling to 7 months, 1 days, 7 hours, 8 minutes so yeah... I had my fair share of experience with various forms of shows and how they are handled.
In the past I followed your advice and if the show went sideways or it ended on cliffhanger I usually watched first (1-2) episodes of the next season and decided if it's worth the time...
I think it also somewhat boils down to being older and not having all that free time and prefering solid stories that actually don't requires 20 seasons to unfold into nothing... Movies are nice but they are often to shallow. Longer movies are tedious so a 10-ep 1-season show for me strikes nice balance - it can have more space to develop characters and unfold the story but it has manageable chunks (that you can binge or not) and has proper ending...