Personally, I'd avoid trying to categorise relationships like that and look for someone being a good partner, someone you trust to have your back and someone you can be a team with, as well as having the other relationship stuff - love, sex, fun together, enjoying spending quiet times etc.
I had a slow burn relationship with a very nice guy for 20 years. We were.. content. Or so I thought, but it's easy to dismiss red flags when you're in a relationship. After a few years, we basically became house mates. Got on fine but that was the extent of the relationship the rest of the time we were together and eventually, we basically just lived separate lives. No drama, just mates, until I realised we weren't even a team any more, we were just two people living in the same place.
Afterwards, met someone and had all the sparks and fireworks. He wasn't a narcissist, he wasn't unreliable and, several years on, he's supportive, loving, affectionate, protective of my feelings, responsible and does housework without any prompting. The sex is still great and the spark's still there for me - he says he feels the same.
So, I don't think a slow burn relationship is a reliable indicator that they're going to be good partner material. Rather than go to the opposite extreme of what you're used to (which was my original mistake) - why not taking some time away from men in general and work out who you are, what you like doing on your own, what your opinions and interests are, then you'll be in a better place to find someone who works with you in that way?