Water based, cream based (face & body) and alcohol based.
Ive never personally used the alcohol based.
I use the water based for my eyes, whenever i want a bold look, or to help my look stay all day, or to help adhere pigments or e/s. I also mix it with pigments to create either a really metallic or satinny look.
The cream I use on my face or wherever when I use glitter. It really helps it stick, and it stays put with it, but I dont believe it is eye safe (hence the water based one).
HTH!