Water based (watercolor, guache, acrylics) dries a lot faster and with watercolor you can get certain effects, like that "watercolor look". Oil based is great for thin glazes and gradients. Egg tempera is in between and can act as a connection between the two.