I owned an APC a few years ago that was very quiet - I kept it in my home studio room and the computer fans were a bigger noise problem than the APC.
In server rooms where I have worked, the UPS units there were always much noisier than the unit I had at home, even units with comparable power. I would bet that there are still some units that are quieter than others.
When I setup my APC unit I tested the switch-over time - I never had a computer re-boot or lose data during the switch-over, but I imagine that some units are better at this than others.