Personally I loathe McCoy and have never understood why people like him. He's flawed to the point of generally being unlikable.
To me, a great character is one that not only has flaws but is able to overcome them and change and grow over time. One of the best characters in Trek overall was Nog. He has the most well rounded character development of anyone in Trek.