I've had good and bad experiences with doggy. For the longest time, it was my 'favorite' position. Then I really thought about why.
At the time, I was married to a narcissitic ass. I didn't want to have sex with him, much less look at him, so doggy position was the best option.
I didn't have to look at him, and I could drift off into my own little world and pretend he was someone else. Anyone else.
Once I got away from him and started enjoying sex with people I actually liked, I still enjoyed it with certain people (length was a big determiner as to whether I would agree!)
As for now, my husband is (for me) the perfect length for doggy where it hits the good spots but not anything painful and gives him great access to smack my ass.
It's not a position we use each time we have sex, but there are times I just love being bent over and taken. The trust is there, so it's pretty fantastic.
I can only imagine I would feel similarly to you had I had these experiences!!