fix: finish database cleanup after slow Gateway shutdown steps (#201693)

* fix: finish database cleanup after slow Gateway shutdown steps

Treat close-step grace as diagnostic and join the actual operation before retiring plugin metadata and databases. Preserve the process watchdog and withhold seals after failed native close or checkpoint. Add a transcript-lifecycle regression and a production-shaped synthetic process probe.

* test: use a bound shutdown probe without lint exceptions