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.

I had Plex running on a Windows server first, then locally on my Nvidia Shield, then on my FreeNAS as a jail. I used it from 2013 to 2018 or 2019. My library is only about 3k files. Plex would get slow, then start serving titles with missing metadata, then start spinning. The only fix was to purge the database and rescan the media, losing all watch data. I worked through backing up the database multiple times, but the backup was only usable for a narrow window of server versions, and was extra work Id prefer not to have to do.

Really, the phone home and pushing for Plex Pass were more consistently annoying for me, and besides, after the switch, I realized how much more I get with the simple setup Kodi allows. My NAS is doing less work, and Kodi does so much more than Plex, minis theme music for shows,/which there is probably an add-on for, but I won't chase it.