After watching a good part of the Beatles Special "Get Back", I have to say my impression was that George was not impressive as a contributor to the band.
That was the time that Harrison had pretty much checked out of the band. All in all, I think he brought some interesting work to the band.
As for My Sweet Lord, I give him some credit that he acknowledges a higher spiritual power of the universe. It's just unfortunate he didn't find the true one.
I read a book a couple of years ago, about the last recording session of The Beatles. It was called:
Solid State - The Story of Abbey Road and the end of The Beatles
The author was Kenneth Womack.
It was a sad read for me as I grew up with The Beatles. I remember we were at my Grandparents home and they had a very small screen t.v. there and me, and all of my cousins, insisted on watching The Beatles on the Ed Sullivan Show. Reading how fractured they had become with one another was just sad.
Now, I remember listening to some radio show some years ago, and the dj asked the question: "Which Beatle was the first to record a solo album?" I was surprised when they said the answer was George Harrison.
One thing I learned with the Solid State book was that Ringo and George were only allowed one song per album, the rest being Lennon and McCartney. Well, George was writing music all along; but, that stipulation meant that not a lot of it was put on a Beatles album. But, once the band, disbanded; he recorded an album with his music on it. So, he was writing music; but, he couldn't record very much of it at the time because of the way the albums were produced -- as mostly a Lennon/McCartney production.