I've recently install and used Cacti, Nagios, ZenOSS, and Zabbix. I've setting up each to monitor my network using SNMP. This has gone on now for about 4 months.
Nagios was a bear to setup while ZenOSS and Zabbix took about the same amount of time. Zabbix kept on corrupting itself after about 2 weeks. ZenOSS wasn't easily customizable and the best features you have to pay for. Nagios took to much time for me take get the most out of its package. Some packages had better incident and case management utilities then others. Cacti was the best long term solution for me. It was easiest to setup and customize. In the long term I found its interface easiest to use to browse over my networks stats.
I'm curious to get other peoples opinions and experiences.