What adds to the "boring" factor for a lot of people is that this game really meant to be played within a corp with others. If you try to play it a solo game and do nothing but agent missions or mine, you will be bored in no time.
Some of my most memorable gaming moments are from this game when I was part of a corp and we were doing mining ops in 0.0 sec space, or went to take down enemy bases etc.
Running through gates in 0.0 with an industrial ship packed with goodies was always exciting and required lots of coordination with other corp members, scouting ahead etc. The othe good one was pirate hunting, leaving a miner in the field and a whole fleet is cloaked waiting for the pirates to ambush the mining op.