I was travelling through North Carolina this summer, and The Time Warner system in Asheboro, NC had an 80's era character generator for their community channel (with the hometown County music AM station in the background). The other TW systems I noticed had newer graphics systems (including PowerPoint), but all carried the local hometown AM station for sound.
Where I live, when Acworth (GA) Cablenet (operated by the municple government) started in 2001, the community channel (and the educational and government access channels, which were never used for their intended purposes) sported more modern character generators, and they used a Music Choice channel for music. In 2003, they switched to Microsoft PowerPoint for the community channel (the educational access CG died and was never replaced, the government channel carried the same CG with most of the same info from the 2001 launch). Cablenet folded this June, and everyone went to Comcast (which had been competing with Cablenet).
Growing up with the system before Comcast (before Cablenet was available), the Community Bullietin Board was a CG that aired when other video programming was not on (which was Cable Channel 2 on that system, WSB-TV has always been on Channel 3. Cablenet copied this lineup when they launched. Comcast, back as AT&T Broadband, moved the community channel to Channel 25 about 2000.)
Comcast fills non community channel programming with...infomercials. I wish the FCC would ban this, and require a community channel/public access channel that cannot carry commercial content. Right now, it is up to local governments to require this type of channel or not. Only a leased access channel (which is the community channel I am talking about) is required for all cable systems with more than 35 channels.
As for 24 hour weather info...The Weather Channel and sister channel WeatherScan serve that purpose today.