This whole "TV" supplier pipeline needs to change in Connecticut.
I recently left Frontier when they dropped YES. I chose Comcast/XFinity because they guaranteed me the YES Network.
What Comcast didn't tell me is that our local CBS affiliate (3/WFSB ) would be available but not in HD. Also, my local CT Fox and NBC channels aren't included either. I've lived in Fairfield County my whole life and have become spoiled as having access to both NY and New England affiliates from major networks.
Positives of Frontier are I got extra NFL games every week because I was catching HD CT and NY signals here. Negatives of Frontier, everything else.
Comcast has been great when it comes to customer service, quality of services provided, having YES and SNY but has been disappointing when it comes to local TV coverage/access.