Ever date someone that makes a good friend but incompatible partner?

This keeps happening to me…..

I'll meet someone, we'll start dating and we'll be incompatible in a relationship for one reason or another.

Then, the person will ask to be friends, but I want the relationship to work because I will have this infatuation and vision in my mind.

And then things just kind of drag out and the prospect of a friendship probably doesn't work out.

I have a hard time accepting the friend proposition the first time it's offered. Even though I usually know that we are incompatible in a relationship and being friends would be better.

It's probably not a healthy behavior.

Or we do become friends…. but at some point maybe I'll try to have sex and then that ruins the friendship…

anybody ever have any or all of these situations?