Is Sport mode automatic?

I'm curious, when it comes to vehicles equipped with Sport mode, is this feature automatically engaged or does the driver have to manually activate it? I've heard mixed opinions and would appreciate some clarification. Does Sport mode automatically kick in based on driving conditions, or is it solely under the driver's control? It would be great to understand how this feature functions in practice.