is the mainline situation any better than with ARM?
Unfortunately, sounds like "no" currently. The ones that let you install Debian usually provide some kind of custom Debian image for that specific SBC. Like you, I'm not really a fan of that. But apparently there are some desktop motherboards with RISC-V CPUs coming out. Hopefully that will increase the chance of things getting supported in mainline distros.