The last two upgrades have broken my audio setup.
First the options for Network Server and Network Access in paprefs were greyed out and my sinks disappeared after upgrading to bookworm. I just had to create a link to an existing file and it was working again but, it's weird that it was needed in the first place. Pretty sure it has something to do with the change from pulseaudio to pipewire but I'm not very up to date on that subject and I just want to have my current setup to continue working.
Then yesterday I just launch a simple apt-get upgrade and after rebooting my sinks disappeared again. The network options in paprefs were still available, but changing them did nothing. I had to create the file ~/.config/pipewire/pipewire-pulse.conf.d/10-gsettings.conf and stuff it with "pulse.cmd = [ { cmd = "load-module" args = "module-gsettings" flags = [ "nofail" ] } ]" in order to have my sinks back.
I know it's not only a Debian thing, as I can see this happening to people on Arch forums, but as Debian is supposed to be the "stable" one, I find it amusing that a simple upgrade can break your sound.
Thanks to pipewire's pulseaudio emulation transitioning from one to the other is effectively seamless. Just install the pipewire pulseaudio package (it's tiny) after installing the rest of pipewire and apps that depend on pulse just work.
I added the script to my post. It's not really that much and could have been done from a guide, but it sure as hell made it nice and simple.