Metadata: Add METADATA/TMDB debug behind a debug option in settings:dev

Also add more verbose logging when option is turned on

refs #2354