CIDER has been the best programming environment I have experienced (probably haven't tried enough of SLIME though). It combines coding with dynamic experimentation in such a fun way.

For literate programming, the Clojure/Clojurescript ecosystem keeps bringing up fascinating environments (in addition to CIDER+Org-mode and Clojupyter).

https://github.com/metasoarous/oz

https://github.com/jsa-aerial/saite

https://github.com/pink-gorilla/gorilla-notebook

are all actively developed and worth following, and they are all rather innovative in the ideas they bring to the table.

For polyglot reproducible literate programming, there is also https://nextjournal.com (implemented in Clojure/Clojurescript).

The pain point with CIDER for me has been, the complexity of setting it up and keeping it current (so many components to it Clojure, leiningen, cider, nrepl, etc), and the fact that it can't drop to a live REPL at the point of exception.