Update: I did randomly come across Home Assistant Global Health Score, which isn't quite what I need but does assign an overall health score based on hardware performance and system hygiene (updates, database size, backups etc). I might try using this for the HA part of the RAG status.