The secret is to not work from what you'd like to do, but to work backwards from what your players want to do.

Seriously, throw out all the prep you have that isn't landing, and just ask your players what kinds of things they want to do. Then, make stories inspired by the actions or accomplishments they want to undertake.

... This does require that your players have some idea of what they want to do, though. If you have checked out or uninvested players, there's essentially nothing you can do I'm afraid.

So now I will soapbox to the players reading this: Your job is to be invested in the game. If you don't put energy into being invested, you're not fulfilling your side of the arrangement at the table.