Is it normal to want a spanking by the opposite sex

So I don't have that liking but I know other women that really do

The answer to your question is "maybe" and maybe it is desirable for some people. I am sometimes thrashed by a young woman but she is my legal guardian and if she puts me over her knee, it is for a good reason. She spanks me very hard and I cannot imagine anyone wanting this to happen as the pain is quite intense.

I was spanked a lot when I was younger, I don't think it had the intended effect