compat wise I think many packages are now available for rv specifically or as .noarch.
perf wise, I think we're still a ways off, we're not seeing rv SoCs at the same level of perf / efficiency as arm, and whilst that's just a matter of time, I'm not sure you'll have many compelling offerings even a couple years from now, though potentially in 2030?
you can check in with experiences using devices like the PineTab V or even the custom RV mainboard for the Framework 13. There are also several SoCs produced by SiFive on SBCs, some are card sized, some are mATX. These are primarily positioned as development devices, but they may give you some idea of what things are like right now