Abelardo Morell is known for taking beautiful, eerie photographs using camera obscura. Lensculture has an audio interview with Morell, as well as a color slideshow of Morell’s work.
On a related note, someone has written instructions for turning your bedroom into a camera obscura.