I finally updated a couple of months ago after putting it off forever and it's been fine for me too. I'm on Pro version and I just used this as the first step after upgrading: https://github.com/Raphire/Win11Debloat
No issues so far, no ads, none of the complaints others are seeing. I'm a power user too: I do gaming, programming, music production, video editing, etc. All of those things are fine.
My only real problem was not being able to have two rows on the taskbar, which I solved with Windhawk's "Multirow taskbar for Windows 11" mod. Done and done.
The average home user probably won't know what power shell and GitHub are.
I can't run the scripts you are talking about on my work pc.
I can sympathise with your point of view but it does feel a bit like "works for me because I know what I'm doing". Also how long before another Windows update that undoes what the scripts do.
I used to be very pro windows simply because of backwards compatibility and hardware support was ridiculously good. I can't recommend Linux to relatives as they'd be utterly confused.
Dave Plummer, ex windows kernel dev does a good job of explaining what the issues are:
https://m.youtube.com/watch?v=oTpA5jt1g60