How in the heck did I miss this thread? I mean this is what I do.
The 2524 is designed as a T1/ISDN router (also known as a serial router) ... you would not be able to use that in conjunction with the cablemodem.
The 2950 is an entry level switch that is very flexible and can be used in most any application. You could use the cablemodem with this switch no problem. You could configure one port as a trunk port for the cablemodem/or another router and then hook up multiple computers to the other interfaces (as long as you have some way to get multiple IPs, either another router or directly from your ISP, most cable providers only give 1 IP via DHCP with their service).
I would snag the 2950 and pick up a cheap router (Linksys or the like).
Chris
CCNP