Improve usage of package_size_check

Alongside #9421

We should improve the usage of package_size_check. It is currently run as part of the manually triggered package checks. Which can cause bumps in size to be missed when they happen.

Options:

1. Run on the nightly build and alert if triggered
2. Make the package trigger checks automatically run in certain conditions (changes to the config directory, and?)
3. ???