The last week I was looking for a device that will allow me to connect a second monitor at my macbook. After a bit of investigation I ordered the Diamond BVU195, which is a usb adapter that outputs the desired DVI connection. After downloading and installing the required drivers, my 2 monitor setup was ready.
Tiger, Leopard & Snow are supported from a stable version and there is a beta one for Lion, which I did not test yet. Overall, I would recommend the BVU195, as a relatively cheap solution. However, keep always in mind that you will be left only with one usb port available (but worth the pain, all the way…).