There's a time and a place for humor and whimsy in a campaign. There's also a line at which point it just comes across as out of place, poorly conceived, and gauche.
You can do it right (Pathfinder goblins for instance), but comedy in D&D often very much overdoes it and does it in places where...