Where can I find a list of what works local and what trys to work in the broken ST cloud?
If you mean a list of what is eligible to run locally, there isn’t one. Just what we’ve been told or observed. Smart Lighting (that specific smartapp, not lighting in general) automations will run locally if all of the included devices have device handlers that are eligible to run locally. That seems to be most of the standard official zwave and zigbee device types. It does not include Hues.
If you mean a list of what is actually set up to run locally at your own house, the community-created wiki has the links where you can check that: