Revisit hard fork activation inheritance behavior

[alfonso-op]

Currently only standard chains are eligible for automatic hard fork activation (see Hardfork activation inheritance behavior).

However, non-standard chains may also be interested in and benefit from automatic hard fork activation.

We need to understand what the specific requirements are for applying hard forks uniformly and whether these need to continue to be restricted to standard chains (e.g., in the event key handover is a strict requirement), could be expanded to standard candidates or even to frontier chains.