Would love insight from you you intuitive Scorpio Men

I worked with a 38 y.o Scorp in marriage with 2 children but in an open relationship. He hooked up with many women but never him and I.

We didn’t hook up specifically bc his wife said no to us.

But for 14 months he continued to share eye contact with me across the room, and share crazy secretive sexual and emotionally intimate energy with me. We flirted through secret talk away from others about sex. And near the end of our encounters he would open up to me emotionally about his marriage struggles and life struggles.

When it came to an end (I moved 2 hours away) we said goodbye and I can’t forget the way he turned to me and said he’d miss me but this departure was meant to be.

He’s still in my mind a year later and I wonder;

Did he care about me more than the girls he hooked up with? Why would he cut me off like that?

I miss him a lot!