How the hell can a router handle an internet connection like cable or even DSL?
PPPoE.
At my dad's house, the ISP-supplied modem is in bridge mode. It then connects to the wireless gateway/router, which uses PPPoE to login and then connect to the Internet, and then send this wirelessly.