Hi, I have Windows 11 24H2 on my workstation. I update it as soon as every official Windows 11 update is released, and I have never had any BSODs in a few years. I use this workstation for heavy work like rendering, compiling programs, etc. and I also produce music as an amateur. I use Ableton Live and I've never had a problem with it.
A BSOD is essentially a self-protection mechanism for the system. Usually only a driver or hardware failure will cause it, I've never seen a system generate a BSOD on its own, either with Windows 10 or Windows 11.
There are indeed times when a BSOD appears only on Windows 11 and works fine on Windows 10. But this is usually due to some incompatible software running at the kernel level, which is usually resolved with a software update.