Emacs should be a good choice for everything, which is my point :-)
Just because you can't easily get it to be great at one thing (lsp) doesn't mean it needs to be abandoned for everything else.
LSP is so much better than alternatives to work with that I feel compelled to make it work and work well. Even for python, running pyright pays dividends for me. But luckily lsp-bridge looks promising so I don't feel like I need to jump ship for VS code quite yet.
To be frank, for Python I still use just elpy - it's good enough. The biggest headache I've had on Emacs with Python is dealing with virtualenvs.
If you are familiar with python I totally believe that. I find LSP to be the most useful in languages that I rarely use, of which Python is one. That way I can constantly, immediately and instantly see that I am doing it wrong.