I am also a parent of a kid who participated with a soccer club team for many years. She is a multi-sport athlete who loved several sports and we found the club experience in soccer actually quite good for her emotional and physical health. I will say that family experience with club sports varies based on the quality of the organization. She also played with her club in falls and her other sport in the spring at high school, so she got to do both. This was fun for her and us.
Assume a kid just wants to get better at some sport. I'm a player development nerd and believe most kids would be better served with 1-1 training with a much lower time investment that just joining a club or travel team. I do 1-1 sessions with players for 30 minutes 2x/week for 6-8 weeks in the fall. Players, of all natural athletic levels, will make about two years of progress compared to just participating on the spring team. That's with one whole hour per week of time invested. I love working with players this way because I am measurable-metric driven, so a kid can see their progress. I'm also a little bit qualitative about it too, because sometimes, the goal is just to build confidence and comfort.
The approach I'm describing looks like lots of hobbies. Imagine a kid wants to learn piano or guitar or drums. It's basically the same abstract approach. Work with an experienced teacher, commit to a regular+reasonable practice schedule, repeat for 6-8 weeks, and see if it fits and feels good.
The social aspect of being a good club or travel team is nuanced, but I will just say that my kid was incredibly well-served by having a good group of friends not connected to her school. And she had a great group of friends in school.