We use Cacti for this purpose, but it still requires creating custom
datasources for the vendor-specific SNMP MIBs.
+1 for cacti.
I think pretty much everything requires bringing in the mibs and setting
up mappings etc.
I've used Nagios/Cacti/Ganglia/MRTG.
