I think there are multiple levels of competitive golf. At the club level, I view those events as just fun so I really don’t get too hyped up. My advice would be to view it as a way to meet people at your club and develop friendships. Those that take it too seriously (I’ve had them as partners) really sour the experience IMO.
I think I’ve logged several hundred stroke play competitive rounds at this point, and they are definitely very different. That kind of golf can go either way for players. It can ruin your enjoyment of the game because when things go wrong, you feel like you’re on an island - no one can save you and you’re not gonna take an X on a hole.
However, if you have the right attitude, tournament play can be another exciting level of competition. I just don’t recommend it for most players because I don’t want to see their enjoyment of the game ruined. I view club competitions as a happy medium because it’s about community and friendship. And maybe you get some bragging rights if you play well!