I don't really keep up with MLP lore so this was an interesting introspection.
All that to say, it's kind of funny Dave winds up having the epiphany about coolness and Dirk is the one to tell him he doesn't think Dave is cool in the way that doesn't matter.