Download Watcher is an application that will automatically disconnect a PPP connection once your download is complete, as well as optionally putting your computer to sleep (iBook, PowerBook) or shutting it down.
Download Watcher works with any application (Netscape Communicator, Internet Explorer...) and is especially useful for large downloads.