My parents have comcast in Massachusetts, but I have no idea what they pay for it. They've had it for years, so it's probably whatever their standard rate is. It's generally been okay when I've been home.
I think every place I've lived in St. Louis has used Charter, but until recently those have all been dorms or large apartment complexes with internet included in the bill. I'm currently paying $30/month for 30mbps/4mpbs in my new apartment, but after the first year that will go up to something like $40-$50. I didn't have a modem, so they charged me $30 for one of theirs, and then proceeded to charge me another $30 to come out and replace it two weeks later when the one they gave me crapped out for no reason. That kind of pissed me off. The service guy had zero clue what was wrong with it. The only thing that really irritates me about them is that they insist on calling me every few weeks to ask if I want to add cable or phone service, even after I repeatedly tell them that I don't want either because I have neither a land-line phone nor a television. Next time they call I'm planning on asking to speak with their manager to complain.