So it seems there isn't a way to get the wallet status directly from the exchange without human intervention, right? (e.g. manually checking status page, twitter feed, etc)
Yes, it totally depends on the service on when to down the wallet for scheduled maintenance.
I wonder if a possible workaround could be implemented via the blockchain. I say this will a limited technical knowledge but I'm hoping folks with a lot more know-how could shed some light. But if one had the wallet address for a specific coin on a specific exchange, given the ledger is public, would it be possible to pull the date of the last transaction for that wallet? If the last transaction was weeks/months ago, it is probably fair to assume this wallet is offline. Thoughts?
That is not fair. Most of the exchanges either provide new wallet/addresses for transactions or keep a dedicated address for every user. These details are obviously public and could be seen on any block explorers. I'm not sure what offline indicates here but technically it is never offline since money could still be sent to it and the details will always be on the chain.