This is wisdom. A life without humor is a sad life. And the best kind of humor can be thought-provoking.
Many people think humor is unwelcome here, but that just isn't true. You identified some types of humor that are very unwelcome here, along with some that can go over quite well.
A few of my highest-voted comments here have been off-the-cuff humorous remarks. But they weren't the kind you would find on some stupid Reddit pun thread.
If I could share one example to illustrate... A few years ago there was a news article that said homeowners in London were digging far underground to build multi-level basements. They would bring in a digger (like what we call a backhoe in the US) to dig out those basement levels. It would dig down and down, excavating each level.
And then, because it was too expensive to retrieve the digger, they would just have it dig out a little hole on the side and park itself there, never to be recovered.
(There were suggestions that the story may have been apocryphal, but that isn't relevant to this discussion.)
My comment was:
"These diggers are the very definition of a sunk cost."
If anyone doesn't see the humor there and how it might be the kind of humor that could be well received here, let me know. I try not to be my own Joke Explainer, but will be happy to clarify if needed. :-)