I think Zofia is very charming, youthful, it's shine of morning light. Svetlana is more elegant, maybe more serious but also lovely & beautiful.
I'm sorry that people made you feel this way about your name.
Always correct people on how you want to be called, nothing wrong with having boundaries and wanting to be comfortable.