I think the actual problem is that you fall into a pattern of thinking about either/or about people when in reality it's more like "a bit of this, a bit of that, a bit of the other."
What I mean is, someone can be exciting in some parts of their life, and uninteresting/safe in others. It is possible for humans to be very active and interested in hobbies/activities, AND be organised and sensible about the everyday stuff eg paying bills.
It can be tempting to fall into the trap of thinking that if someone is really sorted and has a very smooth day to day life without crises then somehow they must be boring too. But logically that holds no water at all - surely as adults we can manage to do interesting things and also manage to keep a roof over our heads!
You also need to consider that what other people think of as vanilla, you might think of as super-spicy, or vice versa. I would think a partner who wanted to constantly socialise with others very boring as I hate it. But they would probably say I was boring and vanilla because I hate parties and would rather spend time on individual hobbies.
You're never going to find a perfect partner, because we're all human beings. Also thinking long term, your tastes will change over time, so the guy who may have been close to perfect in 2021 could be a pain in your arse by 2031. Having children changes your priorities massively, as does working on your self-development.
The one thing I definitely couldn't settle for would be vanilla in the bedroom department. An active, non-monogamous, experimental sex life is vital for me. I've tried settling on this point in the past and it just doesn't work and causes pain all round.