Greetings,
Sorry for your troubles. These are always tough posts to hear about or read.
Start with the basics:
Attempt to invoke boot from the back up BIOS
If this fails, disconnect power from the board and attempt CLR_CMOS using jumper (battery remains in) test again
Strip the board down to CPU, Cooler and One stick of RAM installed in the slot farthest from the CPU socket. Connect monitor to onboard graphics. Perform steps to CLR_CMOS again and see if the system will start.
Now you should have a pretty good idea how "dead" or "alive" the board is.
General thoughts:
Not sure about the troubleshooting steps you took prior to re-flashing the BIOS a second time. Z370 BIOS comes preconfigured in UEFI with the controller operate mode set to AHCI. It is recommended that you confirm the presence of an installed NVMe device in the BIOS under applicable heading after a flash, and also verify it in boot order . While the newer BIOS' do reset themselves after flash, I always load set up defaults, save and allow the system to start again before entering BIOS and reconfiguring from scratch.
Since Intel RST and UEFI RAID are part of the BIOS, its is important to image your m.2 arrays prior to flashing as you will lose the array on reset. *Based on preliminary reports from others. (Realize you are running one drive) Comment is for m.2 RAID users.
For future, recommend that you not update your system if you are stable and are not trying to add compatibility or support, fix a specific problem, or address a security issue. I hope you can bring the system back up.