If you say that you need something or someone like a hole in the head, you are emphasizing that you do not want them and that they would only add to the problems that you already have.
[informal, emphasis] We need more folk heroes like we need a hole in the head.