I've built a couple of experimental languages back in 2019 (so the feedback might be outdated). My experience is twofold. Once you learn MPS basics it is quick and easy to create simple languages/editors. But once you want to step outside or use some advanced feature, you can feel lost for days as there is little documentation.
Overall, I find MPS overcomplicated. There is a ton of docs, but they are not enough. There is a two-part MPS book that has more details, but even it is not enough. There are many places in the book that go like: "there is thing called xxx but I could not figure out what it's doing."
Though, there are some advanced languages like
http://mbeddr.com/ and Java'ish one that comes with MPS, and I believe there are companies betting on MPS.
My general recommendation is to try MPS and/or mbeddr and see if you like them. MPS has many interesting ideas and is the most mature structural editor, so I recommend trying it out to anyone working on structural editors.
If a regular text-based DSL works, I wouldn't use MPS. If you want a structural editor and non-text elements, then MPS is worth it.