First, you need to actually value interesting work in relation to other job values (like compensation, good working hours, low stress, making a difference, family friendliness, good management and many others). Generally these will be a tradeoff, but you might find one where the tradeoff suits you. For instance I had a job I really enjoyed at an Earth Observation startup geeking out about maps and space, but the comp was pretty mediocre and the management abysmal. But it was enough for my needs at the time and I'm reasonably good at managing up so it didn't bother me too much. Many of my former colleagues left that job dissatisfied, since the tradeoff wasn't to their liking.

Second, always be looking. You are right in observing that 99% of job ads seem totally boring. Partially this can be helped with some filters on job boards, I tend to just filter out "Finance" and "Advertising" since I know that I have basically zero interest in those domains. But the chance that you'll find a great interesting job where you skillset is even vaguely compatible at the time you need it is pretty low. It's better to keep looking well before you need to.

Third, if you meet someone in your field who's working at a place that seems interesting, ask if they're hiring. Even if not, there's a chance that next time they are, the person will remember you. Or perhaps in their next company...

Finally, cultivating a broader skillset rather than a highly specialised one can make this easier, since many interesting companies are probably not doing the exact same everyone else is, so they might need someone who seems more adaptable.

Good luck!