I can provide some info on boys teams:
Genesis - one of the larger programs with a number of teams meaning kids of every level get the opportunity to play club ball - fees around $900 I believe. A great roster of young coaches. Elite teams at the upper end.
CYDC - another of the larger programs so plenty of levels of teams - a little more expensive $1400ish I've heard. Elite teams at the upper end.
Foundation - a smaller program with one team in each age group but top quality coaches and the teams are always at the upper end ($1200 ish)
Red Jackets - smaller as well but have fielded pretty competitive teams, not sure on cost but likely in the middle
Selects - same as above
Storm - same as above
CBA - this program is new, has been strong on the girls side out of the gate and recently merged with NSD on the boys side I believe so some good coaches coming over
NW Locomotive - growing with some great coaches on the boys side
WIN - I believe just a U17 boys team last year but a good one with good coaches
Some of these clubs play in the CMBA spring league but most play in a club only league run by Genesis and add tournaments on weekends.
On the less competitive side, many of the communities enter spring league teams into the CMBA spring league but you'd have to go to the specific community for more info.
Sorry if I missed any - others should add.