The first task you have at hand is to get kids satisfied and asleep in an optimal time.
Likely, it's about the ritual, about putting the visible, sensible effort in.
For that I'd recommend trying to do voices. Assign a voice to each character and stick with it, with a separate "narrator"/usual voice. If it's silly, so be it. You're an adult with your own kids, there's no one to reprimand you for silly voices.
Then read whatever you like and think is appropriate to your kid(s).
My elder told to my wife recently that he doesn't understand half of what I'm reading to him and that he doesn't care at all, as long as I read and then carry him to his bed.
From my perspective it's u likely that you need to pjt in more effort in stories, i.e. modifying them and such. Likely, you'll be ok with reading what you like with sensible gusto.