Yes, sometimes I like a spanking to end with some tears. Most of the time, spankings are playful, whether they're just a few swats with a hand or a certain wooden paddle that STINGS like ******, but it's for the fun of being spanked (or a bit of an endorphin buzz).
But now and then, usually when I'm feeling very relaxed and completely at ease with my partner, I can let go, and just allow myself a good cry. It's usually during a fairly long, slow spanking with lots of body-to-body contact. I've asked for a spanking when I've been upset or stressed out about something, and know that a good healthy cry always makes me feel better.
Pain alone doesn't do it. The hardest spanking I got in my life, I was deliberately razzing my partner, saying they had a weaker wrist than a cheap bartender and whatever other witty commentary I could come up with. It sure worked, ended up with a mix of howling in pain and laughing in between swats, and sitting was "memorable" for several days. Delrin cane. Mucho Oucho! ?