I have apcupsd running on a SME 5.5 server with an APC UPS. It works very well. It provides a CGI web interface with very detailed running conditions, just like APC's software. I also have it notifying several other servers via the network when power fails. The CGI interface tells me if my servers are up and monitors input voltage, output load, etc. It's been a while, but I seem to recall that it was quite easy to set up succesfully the first time. Apcupsd is also very well documented.
http://www.apcupsd.comAt work I have a non-APC UPS on a RedHat server. With the particular UPS, I could only get powstatd to work properly with it. I found powstatd to be simple relative to the others mentioned above. No real valuable information, it simply runs quietly in the background (it seems reliable though). Powstatd is also time consuming to set up. There are 4 or 5 config files which must all be configured. I also found that it wasn't as well documented as apcupsd.
I had tried an APC unit with a USB port and was not able to get it to work at all. NUT is supposed to work with USB, but USB support is experimental, and I couldn't get it to work. Your mileage may vary, but I would recommend staying away from USB only models. NUT is also poorly documented in my opinion.