LOTRO (Lord of the Rings Online) has some incredible PvE content.
I absolutely love the game and think it's amazing. The story content is just great, and this is a game that focuses on PvE, which I love. It has PvP, it is just sub-par to other mmos out there.
One last note, I honestly feel like I am in the LOTR universe when I play this game. It's so cool, and it's really, really good.
PM me your email if you want a free trial, in fact, PM the emails of all your friends who want to play, and I'll send them trials and you guys can try it out for yourself.