It's actually one of my main goals when I'm having sex, to provke tears.
Understand though, don't walk off flexing like macho man. It took me a little while to understand that taking a woman there and not giving after care isn't really the wave, kinda cancels out how vulnerable and open she just was when you just leave it up in the air afterward. Good sex, like a good massage can and somethimes SHOULD release powerful emotions, sometimes trauma related.
Emotions are stored in the body, the issues are in the the tissue as it were..so you may very well knock some stagnat emotions loose if you're doing it right. And how you react could either leave her feeling more free (and eager to please you) or ashamed. Don't freak out if it happens, just check in with her.