Unfortunately, as Patrick Stewart imposed his interests and personality on the character, Picard became less and less the cerebral captain whose leadership style I admired and wished to emulate.
I’m not sure Patrick Stewart has ever understood the qualities in Picard that captivate so many in the peak midrun of TNG.
We can see that with him insisting that Vash (the actress as a then girlfriend) be included in the show (apparently, wanting Picard to "get laid"). There's an entire post about that awful character in the sub-Reddit.