Yeah I've noticed Urania seems like she'd fit as the supreme goddess of the DC Amazons out of all incarnations of Aphrodite. She was even specifically the version of Aphrodite that was equated with a Scythian goddess, Artimpasa.
Historia's Aphrodite seems to be at least partially based on Urania.
As for reconciling Aphrodite from the myth with how the WW mythos uses her, that is true but also not a deal breaker for the WW mythos to work. We are after all already making concessions for inaccuracies with the Amazons (not man hating, not daughters of Ares, didn't cut off a breast, didn't get killed by Heracles, etc).