How can I have healthier relationships with Cancers?

I'm new to astrology.

I'm a Scorpio Sun, Taurus Moon, and Leo Rising. People often say that Scorpio gets along well with other water signs, especially Cancer and Pisces.

The thing is, I've known several Cancers through both work and my personal life, and I've had similar experiences with most of them.

At first, we usually click really well and become friends quickly. But after a while, I start noticing traits that drain me emotionally. I often find their emotional ups and downs, self-centered behavior, and constant need for attention exhausting. Eventually, I end up distancing myself because I feel mentally drained.

This isn't just happening in my current job, either. I also used to argue frequently with a Cancer coworker at my previous workplace.

In my personal life, I can simply end the relationship if it's not healthy. But at work, that's obviously not an option. I'm currently dealing with a Cancer coworker, and we argue quite often. It's becoming really stressful.

For those of you who know astrology well, do you have any advice on how someone with my placements can interact with Cancers in a healthier, less stressful way? I'd really appreciate your thoughts.