`spec_version` warnings should be logged after migrations are executed

[liamaharon]

Currently spec version checks are executed and warnings logged before any migrations run, making them easily missed if the migrations are noisy.

The warning should be logged at the end, to reduce the chance of it being missed by the developer.

The process should also exit with a non-zero status code when there is a spec_version warning, unless disabled.