I was in the same place as you were, and I made the jump right before the pandemic hit. I was really glad I got it, as I was properly distracted when things were just starting.
Sure, you have to be aware of certain packages that are CPU specific, but the awareness of what chip you are running is being talked about more and more, so I see that as a non-issue and is a matter of time before things are not platform specific (unless the have to be, for whatever reason).
I was unable to find any issues with running software that is platform agnostic, and most mature open source applications take into account that you may not run on x86.
YMMV, but the only issue I had was with OnlyOffice. I have not tried to build it on Power since I put the ticket in, but they have addressed the issue of it not building on Power.
https://github.com/ONLYOFFICE/build_tools/pull/87
The WiKi, The Forums, and the IRC are great! I was able to un-brick my BMC by using those resources, so it does not feel scary to get your hands dirty when working at such a low level.
I posted my experiences of this from about a year ago on the forums, its one of the most viewed pages on there.
https://forums.raptorcs.com/index.php/topic,99.0.html
Hope this helps with your purchasing decisions!