The question itself gets at a core tension in mythic worldbuilding, right? An Aphrodite-figure isn't just beauty; she's the primordial force of creation, attraction, strife. Making her husband 'powerful' in a conventional fantasy sense feels almost beside the point. His power has to be relational, a counterbalance to her chaos. Maybe he's a god of craftsmanship or smithing—his power is in making the unbreakable bonds, the artifacts that contain or direct her influence. Or he's a god of war, but specifically the strategy and discipline that channel the violent passions she inspires. The real dynamic isn't about who's stronger; it's about the friction between generative, uncontrollable desire and the forms that try to contain it. That's where the stories are.
I saw a webnovel once where the 'Hephaestus' stand-in was the realm's archmage, binding cosmic forces into elegant, lawful constructs, and his 'Aphrodite' wife was the wild, animating spirit of the land itself. Their arguments literally reshaped the geography. He wasn't less powerful; his power was just of a completely different order—infrastructure versus raw nature. Portraying him as merely cuckolded or weak misses the mythic scale. His power is in enduring, in forging stability from her chaos, and that's a terrifying kind of strength.