The blue kind is the basic one. It holds things on but can be disassembled with hand tools. The red requires heat or power tools to take apart. The green can be applied after assembly and just pulls itself into the threads by capillary action. There's another for nylon fasteners and I think a few more I've forgotten.
Scott