I think if you start there it’s potentially great. Going through the early migration from classic to modern was where the burn occurred in my experience.
I was using Yarn 1 before, and it was a nightmare. Slow and painful to package applications with lots of dependencies and to deploy.
So yes I did migrate to Yarn 2+, and it made CI/CD much easier and faster.