I prefer the Episode missions because the story is like Star Trek shows. Sure there are some cheesy episodes, but all in all I log in to see what's the next episode. I also love patrol missions too, nice and quick in case my commanding officer (wife) wants me to do something else, I can at least get part of the patrol done and AFK fly to the next one.
Fleet Action loot is almost non-existent. I made #4 on DPS and got nothing. /sigh
PvP I'll admit I haven't tried, don't want to embarass myself yet.
Exploration is fun, but seems slower than patrols. It brings me a sense of wonder to do them, though. Just not effective for loot/SP.