Opeth has multiple riffs that totally rock.
3:00 into Godheads Lament is insane. To me, it sounds like the guitar is actually crying.. so emotional.
13:39 into Black Rose Immortal Oh what can I say about that riff. It totally means so much to me. Ive had some hard times lately with a friend and I play that riff things dont seem that bad and I can clearly think about things. So, yea that riff is good and emotional.
The end to Apostle in Truimph is really good too. Just some hardcore guitar action.