When should you ACTUALLY enable “allow tearing”

I understand what vsync is, as well as screen tearing. My confusion is that I struggle to think of scenarios where you would actually want it enabled (like a comp shooter), and that it doesn’t even seem to function properly, as I’ve never been able to get the deck to go above 90fps on low powered games.

Google also doesn’t seem to help, it seems like there’s not too much discussion about the setting for whatever reason.