Country is a great place for this - Vince Gill, Brad Paisley and Keith Urban are all excellent guitar players.
Fogerty and Springsteen are surprisingly great lead players. Springsteen has been doing more lead work on his tours, even with Nils standing by. John Fogerty has focused on his playing over the past decade, picking up his chops. He’s discussed it in a few interviews. He’s a real guitar geek.
Petty - obviously a brilliant rhythm player - the Heartbreakers are an amazing band. I never hear him play lead, now that I think about it, and when he does move, he moves towards bass, e.g., with Mudcrutch, vs. more prominent guitar. Heck, if I had Mike Campbell, I wouldn’t either.
Obviously you have David Gilmour who is prominent in both roles. And yeah, Hagar can play.
But the biggies? Well, McCartney is a great guitarist - listen to the lead on Taxman or the picking pattern for Blackbird.
Lennon? Minor lead work. Jagger, Plant, Daltrey - all can play, but none are standout. Kurt Cobain is a surprisingly economical and powerful guitar player, filling both rhythm and lead roles really well.
Oh - wait! I have one: Amy Winehouse!!!
Have you seen the documentary that won the Oscar, Amy? In it, she is shown playing guitar in a few scenes in the first, oh 45 minutes. She is brilliant - moving jazz chords with lead fills. Very spare and mainly to support her vocals, but her chordal knowledge and sense of melody and rhythm/space jump out. Who knew?? At one point, she she was in the studio, I think, she discussed working on a song using a guitar. She says something like “yeah, guitar is better - I am a guitarist and think like one.” Given what I had seen of her playing that was totally credible - and I didn’t even know she played before the film started.