"pretty dangerous for post-hoc analysis because if (when!) something goes wrong, the information is overwritten and gone forever."

If your last active time table is being fumbled then yes, but I'd worry about all the other parts of your data if that was the case.

Dangerous is not something I would ascribe to a "last active time" table (except if you're using it for security audit purposes)