Overall my attitude towards the game's impact on me is neutral. I could use my time on much more productive outlets for sure (playing music mostly), but tf2 has been really useful as a tool for me to bide time until I can move away from my unfortunate home situation. As well as that, the friends I have met through it are irreplaceable. I have regrets that aren't really attributable towards playing tf2, but I wont deny that playing the game compounded the problems at hand by a fair amount. In reality the only way to have really solved them would've been for my younger self to have had much more mental fortitude, but if I could go back, choosing to get into the game again would be a tough decision.
I wont really say the game has helped me be better in social situations, in fact I would say my internalization of memes is more of a detriment irl, but I will say that it has helped me realize the importance of first impressions and not being a toxic retard. I think one of the best lessons that competitive tf2 players learn is that built up reputations are really hard to dismantle- mostly due to the playerbase being too small to outrun your reputation. While it might be possible to "reset" your identity by starting fresh with a new IP and account (a real life equivalent would be moving far away and cutting ties I guess) it certainly isn't easy or something one would personally want to do.