There's a fantastic wiki of esolangs, detailing all the ones I've ever heard of, and far more. My favorite so far has gotta be Rockstar - it sounds like Bon Jovi on drugs.
Check out the talk, briefly mentioned on that newsletter with basically the same content, but with a stronger feeling of completeness https://www.youtube.com/watch?v=cQ7bcCrJMHc
https://esolangs.org/wiki/Main_Page