In the Cut (2004)

Mark Ruffalo - Scorpio Sun, Cancer Moon, Sagittarius Rising
Meg Ryan - Scorpio Sun, Aries Moon, Capricorn Rising

Everything is just as it should be when an NYC sex and murder cop drama stars two smoldering Scorpios, but when it's also written/directed by Jane Campion!