I finally got my system up and running - and secure with
23H2 (which it was ever since the release) ...... heaved a grrrreat sigh of relief & thanked God
Now I have disabled any windows updates and rather wait for two or more months to see if any of my hardware (along with 13600K) is an issue with 24H2.
The BSOD problem that I faced & system going DEAD was acerbated with the fact that I could not Power On my Case [Thermaltake The Tower 900 as it's main button was dead as also the reset button] - so I got this
Verilux PC External Power Switch & Viola IT WORKED.
Moreover, I did not have to get into Safe Mode to uninstall the failed 24H2 update - windows 11 did the roll back which took about 5 mins only.
I hope no garbage of 24H2 is left behind in any hidden folders!