I'm a big fan of Roon. Switched to it 6+ years ago primarily because I had a number of Squeezeboxes at the time and Roon supported them well. LMS was going nowhere and Roon seemed like a great path forward. With that said, they have had a few issues over the years. Then again, every software platform does and Roon has never given me any serious regrets. Once I switched from running it on an older Win 10 desktop to a NUC running ROCK, it has worked amazingly well. There was a recent release glitch which appeared to mess up the database. But to their credit, they resolved it within a couple days. No harm done - at least for me.
I stream my local music from 4TB USB drive hanging from my NUC which I then backup elsewhere and in the cloud. I don't use a NAS and I have seen a number of posts from NAS users complaining about Roon issues with some NASes so I've avoided that solution. I know a few users that use their NAS for backup, but use a separate drive to feed Roon.
The Roon Community for tech support has been a mixed bag. In the early years, I thought it was an exceptional resource to resolve issues that, in most cases, were part of my learning curve. Getting feedback from experienced users was quite helpful. But given the growth of Roon over the last year or two, the forums have become a bit of a mess and it doesn't take much to start a fire (ah, the nature of online forums, AudioNervosa aside of course). But if you have an issue and stick primarily to the Support thread, it can still be quite helpful. And some customers are quite insightful and help in getting things resolved even when Roon support is slow to respond. Still, I think at some point they will need to adopt more of a ticket-based support system.
I've yet to see a software streaming platform that comes close to Roon if you're a bit of an audiophile and have a sizeable library of you own music. For me, it has changed how I listen to music and, particularly how I discover new music. The downside? It has made me lazy. I rarely make the effort to spin vinyl much these days.