I don’t think I know the name of any other macro photographer but Janet Waters is definitely worth knowing. She does a lot of visual experiments with different liqids creating beautiful pieces of art with formations of bubbles. Here’s a few shots seen through hairgel. Did you ever look at your jar of hairgel and think “Hang on, this is a piece of art!”? Well then, start looking!
If you wanna see more, Janet’s work is easiest accessible through Flickr.