yeah, you can make it work, but it's certainly not as easy as using a regular cable modem.
you would basically have to make your one computer a router (i.e install both the USB modem and an ethernet card) and then you could have the ethernet card run to your hub and what not.
OR, i think there's some routers out there that might accept a usb cable modem directly, but don't hold me to that.
Anyway, if you're in the market, you're life will be easier if you just get a regular cable modem IMHO , but it's up to you