Wow, here is one person’s actual design for a supercapacitor UPS for Raspberry Pi, in particular to support RaSCSI. There you go, there are other folks out and about that are really doing this.
20200922/https://www.smbaker.com/supercapacitor-uninterruptable-power-supply-ups-for-raspberry-pi