I think that Hackathons are invaluable for meeting people you are going to work with long term. However, I agree it's rare that you will do something significant during an 8/10/12 hour hackathon.