There are also some nicely logically contradictory ones that are cleverly done. One SCP in particular cannot be defined, as the act of doing so changes its nature again.
There's a YouTuber called Dr Bob who does an exceptional amount of work animating and narrating SCPs.