The guy seemed a bit weirded out at how profusely I thanked him -- after all, all I'd done was tell him the model and MAC address of my generic Motorola modem.
Don't waste your time explaining to them why you want to use a real modem (I have my own router/firewall, their modem had NAT I could not disable) or that it's the same modem that works on the residential service (which is the same physical network). It won't help, just say "I bought a <VENDOR> <MODEL> modem, can you set it up on my account?" and hang up and try again if they act like your request is bizarre.
http://mydeviceinfo.comcast.net/
(Which has all the usual SB* suspects).
If you want a static IP, AFAIK, you still have to use what they give you.
Granted I still think Comcast is the scum of the universe for myriad and sundry reasons, but at least this aspect of their service was fairly easy to set up. I still miss the FiOS I had back in Boston though :-(