I have never experienced a hackathon, most similar thing that comes to my mind, that I was part of are hackfests on some open-source conferences and those were pretty great.

Usualy a hackfest meant bunch of coders interested in a project sitting in a room for ~5 hours and doing bug fixing, new features, or just discussing. Everything is good in moderation, I guess.