MODEM stands for Modulator-Demodulator, translating digital to analog signals. MODEMs connect devices to ISPs, converting internet signals into readable data. Types include Cable, DSL, Fiber, Wireless ...
Like you say, negligible difference in performance, any comunications between your PC and Modem will be at a speed many times faster than your dsl connection.