So I think I found a way. Not really simple, not really covering everything, but not too bad.
Still trying to get some addditional data points integrated like Supermicro PSU data/temps and Netgear S3300's temps as well.
But i got a bunch of others in my map:
I ended up setting up an Observium monitoring server which can do SNMP&IPMI queries.
Then I hooked up Excel to the embedded mySQL DB and extracted the relevant data and mapped it to my rack layout.
Might need to convert this to a website after all, easier then opening Excel all the time.