What problem does this address?

As noted in #27337 - we should enable special block patterns that only show up when specific template part types are selected (such as header or footer).

Also related to - #27575

What is your proposed solution?

Once #28410 lands, we should have a way to distinguish what section type a template part corresponds to. This should open up the ability to link block patterns to them.