As far that I know, with Dual LAN and two ISPs you could do Load Balancing for Internet purposes, or have some form of automatic redundancy if one connection fails. The problem was at the Software side of the things, specifically on Windows based platforms. At least I heared that some people with old computers with 3 NICs and 2 ISPs could repurpose them as firewalls and load balancers using Linux as OS, then using the last NIC to send that to the router and feeding multiple machines. This was apparently easy to work with once set up properly because for all the other machines but the firewall one, the fact that they were using 2 ISPs simultaneously was transparent.
During 2008 I had 2 ISPs, a single NIC for a Cablemoden and a USB ADSL Modem. I spended quite a bit of time but didn't managed to make them work simultaneously on Windows XP, you needed additional Software, which were paid, and I couldn't even get the trial versions to work. Some of Windows 2000 Server editions supposedly had Load Balancing support built in.