Never give up. I recovered all the missing funds from my corrupted CLN database. On the bright side… I learned a lot about the workings of Lightning, the differences between P2WSH and P2WPKH, and how exactly CLN stores all the details. I am hardening my new server to ensure I never have to go through this pain again: UPS, RAID1, use BTCPayServer instead of rolling my own and ideally going to figure out watchtower too.