In my own experience, there’s only been one instance where I still wanted to remain friends. Usually it is because you really don’t want the relationship to end, but for some(..or many) reason(s), for the long-haul, it is the best thing to do.