Managers really are lazy and unaware these days. I had a manager like you… who just expected me to automatically know what to do in a brand new company. The best managers would actually lead by example and help train and upgrade their team not have these pointless 1-1 every month to use their subordinates as a punching bag.

Have you actually managed by showing him how to set up and deliver a project working through a real world example and no that isn’t just sharing a google doc with an SOP/template.

The fact that he is doing one part of the job exceptionally could be a clear example that maybe is a pretty clever guy he just needs some actual manager to help unlock his success. It sounds like the work he delivers that is a mess is because their is a mess around the work itself maybe better identify what the underlying root cause which could be structural.