Different groups use different languages and techniques, but most tend to use assembler I think.

The 4K intros can definitely blow you away with what they can fit into them, with the Amiga and PC...