The discovery channel a few days ago ran a special that pretty much summed things up as far as how hyped the comet was. They called it 'The Hunt for the Supercomet." While interesting, it was way overblown in how important the comet was, but in the end they did admit how much of a disappointment the comet was. Yeah, so more like Superdud.
The next comet already proposes to be more interesting. Keep an eye out for Lovejoy.