Personal anecdote: I connected my guitar to my shitty sound card a few weeks ago, ran guitarix (because real DAWs are overwhelmingly complicated and I just want an amp, a compressor, and some reverb), and thanks to PipeWire and pipewire-jack everything ran perfectly. Low latency, no crackling, no messing with jackd or ALSA, no restarting audio daemons, I could simultaneously play audio through Firefox and hear my guitar. I dare say that that part of the audio stack is now a solved problem.
I'm not a musician though so I can't comment on hardware support for exotic sound/midi cards or the maturity of FOSS DAWs.