If you are the kind of Linux user that treats your OS like a pet, with lots of TLC and endless tweaking to get things "just right", then Silverblue is a terrible choice. It is way more difficult and time-consuming to "hack" stuff together at the system level.
However, if you prefer to treat your core OS as livestock (something rigidly structured and reproducible automatically), then I highly recommend giving Silverblue a try!
As a software developer, I run a lot of random software/dependencies/etc and I have historically struggled with my Linux system stability degrading over time as I add/remove packages and config. My goal with Silverblue is to have a solid base OS that does not suffer from package-drift over time. On top of Silverblue, I use distrobox to run many of my apps/bins in a virtual container. That container is where I do all my "hacking" to get things to work and I consider the container to be expendable. If I start having issues with it working correctly, I can just blow away that container and rebuild it without effective my core system, other containers, or the flatpak apps.