I love all the lore/exploration/fluff. I also love multiplayer, but RP heavy(as in stay in character). As long as you find the right group it can work fine. I have had some great RP based groups in the past. If a player runs off and gets themselves killed, they don't really last long in our style of group. Conversely if a group as a whole wants to rush and ignore all the lore/exploration, the a slower player(like myself) wont last long in that group either. These things are perfectly fine and might just take a while to find the right group. This is why when I post LFG posts, I am always clear about what we are looking for from players.
So for me(maybe selfishly), I want as much lore and exploration as possible. If a group wants to play fast they can easily ignore all that and get on with it. So I say put it all in and let people choose whether to indulge in it or not.