I would guess it's not related. Some like fit guys, other women like chubby or on the contrary very slim and skinny men. Some women adore bodybuilders and others hate them.
Also as with any relationship - much more important is the emotional connection. You can look whatever, but if you manage to treat your woman well and build a relationship - she will love to dominate you whatever body you have.
I'd say in modern culture the safest bet would be fit and slightly muscular - but not a bodybuilder type. That's the most common image of an attractive male body. Think of an olympic swimming contestants, not heavy-lifters.
It's a matter of preference that's not connected to the role - is my guess.