I just had a db corruption a couple weeks ago, immediately after a server update. Easy enough to fix, but super annoying when you want things to "just work".
Like the OP, I'm getting tired and wary of Plex. The fact that they have a native app on most major TV brands is nice I guess, but I'm at the point where I'm seriously considering buying a handful of RPi compute modules now that they're available again and just changing all my TVs back into "dumb display" mode and running all media via the rpi.
I tend to get trigger anxiety on these things though, so I'd love to hear how other people are handling their self hosted media/streamcutting setups.
ShittingWhileGiggling.onion, of course