Lots of bitterness, cynicism, and regrets in this thread (or maybe just one poster repeating their views over and over.)
Enjoy the ride. If the ride is not a net positive for you or your child, do something else. No one is holding a gun to your head and making anyone play club soccer, or pay for ECNL or DA.
For those that like to compete at a high level, they will compete. The memories they have are always of the friendships and relationships. Maybe they'll remember a handful of key games, but its more the people they'll remember.
Soccer is a beautiful sport and its a great way to develop leadership, learn the value of sacrifice, be self-disciplined, embrace teamwork, be focused, and develop a great work ethic. So you missed some parties along the way, but what did you REALLY miss?
Those that are fortunate enough to play and start at a D1 school (or any level really) can make up their own minds. They can either be drinking and partying, or they can go on the road and build great friendships and compete in the sport they love. Does playing soccer at the college level make you happy? If so, then you should have no regrets. If it doesn't make you happy, or the sacrifice you have to make doesn't feel worth it, do something else. If you have an all-encompassing major you'd rather do than meet the demands of college soccer, quit soccer and pursue your major.
For some young women, starting for UCLA or USC or Stanford or North Carolina or Penn State or Notre Dame is a big deal and the achievement of a dream. Its a highpoint, possibly THE high point of their life. I'm not discounting it doesn't work out for some, or that priorities and passions change, or that injuries cut someone's journey short, or that some may get screwed over by a coach, or some just have unrealistic estimates of their talents. Some may certainly feel they wasted their time in the end about soccer after they graduate. Its a competitive situation and there are winners and losers and usually the cream rises to the top, but not always.
At the same time, I've spoken to many college graduates who played at a high level that wouldn't change a thing. It was the best time of their lives.