I’m already playing a Light Cleric of Sune in Rime of the Frostmaiden (though I may have to drop out soon due to scheduling conflicts) who is CG, and my general RP ethos for this character is rather similar to what Tanarii posted, in that Sune emphasizes both inner and outer beauty, with inner beauty being the general “be a kind person” trope salad.

It’s also worth noting that Sune isn not a literal sex goddess, or even the closest to one in the FR pantheon. That honor goes to Sharess, CN goddess of pleasure, though she too is more about general hedonism IIRC.