Yes, I agree. Conditional on some "difficult" languages like Java, the experience is quite different. For non-difficult languages like C, R, and Python, the gap is small.
I've also enjoyed the Emacs/Python experience :)
With JetBrains PyCharm or the PyCharm plugin in IntelliJ, you can treat all python3 as statically typed ... use the type-annotations and then linter will catch your mistakes.
You can also do this using emacs with lsp (specifically with pyright as the backend)
I currently mostly work in Python using Emacs, because I don't know of anything that adds really compelling full-blown IDE features for a dynamically typed language.
I will also say that Datagrip and Microsoft SQL Server Studio are both way ahead of any Emacs SQL packages I've tried.