I personally like the intro lead part of fade to Black by Metallica and a really great solo is the 1st one in Comfortably numb by Pink Floyd. Check them out...Floyd have lots of melodic solos that sound great.
Andrew