We have been working with a pretty cool little javascript toolkit called Highslide.
It gives you some nice lightbox type effects but I like it more because of some of the options to load in iframes and stuff.
Someone wrote some asp.net wrappers as well to make it easier to add to your pages: