I will answer with a French point of view, I don’t know how it is for French speakers outside of France.

We do use Yes as an exclamation, when something cool happened to us / when we won something as you pointed out in your question.
It can also be used as a reply, when something “cool” happened to one of your friend, example:

– Je pars en vacances en Amérique la semaine prochaine.
– Ha yes ! profite bien !

We sometimes use it to replace oui, for example:

– Est-ce que tu pourrais m’envoyer le lien de la vidéo de la dernière fois ?
– Yes ! Je te fais ça tout de suite !

I couldn’t tell how often we use Yes, the only thing I can tell you is that we don’t use it in really formal situations.

I guess we use it only to sound “cooler” 🙂