Doesn't your ISP include the modem in your setup/install fee?
The networking forums are probably a bit better for this question, a lot of very knowledgable guys there.
But, basically, I have never, ever heard anything good about ADSL and USB modems.
By far, it is much better to get a regular external DSL modem.
Also, I believe some ISP's are compatible with only certain modems.