Umm, this sounds like spectacular component failure of something storing rather more energy than yer average (or even two-standard-deviations-above average!) mains spike carries - maybe your PC/server supplier had a dodgy batch of hefty electrolytics, *and* had them mounted - unusually - direct on the board rather than enclosed in a bought-in power supply? Or maybe you had a lot of lightning strikes in your part of the world? Not to belittle the value of UPSen - my home machines and their less power-hungry peripherals typically sit behind one, as much for the convenience of a single power button to turn off all the little bits of kit as for the power conditioning and keep-goingness of the UPS - but the type of failure you mention is atypical, and unlikely to have been prevented by a (consumer-grade) UPS...
Stefek