Actually, if you’re using D-Link class devices (SOHO), and you want increased bandwidth through multiple links, I’d recommend the Linksys RV-042/082/etc. series.
That allows you to use the two Internet feeds either for load balancing, or failover.
The only problems I’ve encountered (and I think it was Yahoo’s fault) is that one time we had FTP connections broken because of “suspected PASV port theft”. This was caused by a single FTP connection being spanned across two IP addresses, and only occurred for about a month.
Overall though, I’d say to do it that way. I’ve done a couple of different installs with those routers and have been quite happy with the results.