I'm having fun.
Apparently you aren't.
The question posed in your title doesn't apply to me, and of course, I can't answer it for you. League of Legends becomes fun when it does. You can't just ask when it will become fun again; I can't predict the future, and neither can you.
You're just trying to farm upvotes by posing a rhetorical question about League's current state.
I'll also speak to a few of your points.
Game balance is in the toilet
No it isn't. There are always overperforming champions and underperforming champions. From what I see, the number of over- and underperforming champions isn't very different than it was a few weeks ago, or a few months ago, or a year ago, etc. Our game isn't balanced, but the balance isn't in the toilet. Stop exaggerating.
Most games are decided before 10 minutes, after which you slowly watch the game move further and further out of reach while you're no longer playing, you're just sitting under a tower "playing" dodgeball where if you win you get zero reward and if you lose you get to watch yourself die behind your tower
The issue of "no comebacks" was one during the early season. Riot has since remedied that with the tower buffs. Games aren't decided before ten minutes unless they are extreme stomps, which are not as common as you are purporting them to be.
10+ minute queue times on a regular basis
And you're getting your two highest priority roles on a regular basis. (Which means always.) You are never relegated to playing your worst three roles unless you fill.
Champions are easier than ever before to hard-counter, so unless you pick something blatantly OP, you're going to be spending half your games miserably trying to get CS while not getting violated by your lane oponent
Riot has been moving away from hard-counters, not towards them. Binary champions, like our early champions, are the ones who are hard-counters or get hard-countered because they have binary kits. We have much more complex champions now, and more complex champions are harder to hard-counter than simple ones.
Also, what do hard-counters have to do with overpoweredness? If what you're trying to say is that if you get counterpicked when you're not playing an overpowered champion then you're screwed, then you're wrong. Counterpicks don't guarantee wins; neither do overpowered champions. Each lane is always up to your skill; do you win or do you lose? I don't automatically lose by getting my Katarina counterpicked by Lissandra. I need to adjust my tactics. I don't automatically lose because my opponent picked Swain into my Urgot. I am going to adjust my god damn tactics. If I'm pitifully farming under tower at six minutes after giving up a kill and being unable to bully Swain, then I did something wrong. It wasn't just my choice of Urgot. It wasn't just my opponent's choice of Swain. If I lost lane, then I did something wrong. Swain may be strong, but he's not unbeatable. A Lissandra might be a daunting prospect for Katarina, but she is not unbeatable.
Massive mobility creep and utility creep on all new and reworked champions
There is more mobility in the game. However, it isn't creeping. Not "all" of our reworked and new champions have mobility, and many have slight mobility. We're also getting ways to deal with mobility, like Poppy's Steadfast Presence and Cassiopeia's Miasma. We also LOST boot enchantments. That the opposite of mobility creep!
