[FEAT] Improve programmatic metadata description acces

@corneliusroemer

We might want to also link to the list somewhere as not everyone will use the website or excel sheet

Originally posted by @corneliusroemer in #1105

Specifically the valid option enum values should be surfaced in docs not just in the template.

@corneliusroemer

@corneliusroemer they are visible in the docs, but can see this isnt easy for programmatic users to get

Navigation Menu