As people have implied, there are at least three issues here -- style, boringness and excitement.
Style -- a conventional stroke-player can be very stylish no matter their scoring rate, e.g. Gower, Tendulkar, Aravinda or Mahela could score 20 from 87 and still be stylish. Classic stylish shots include exquisite cover drives and delicate square cuts.
Excitement -- something happens, be it a huge six, a run-out attempt from a crazy single, or an edge over the slips. This may not be stylish in any way, shape or form, but it's exciting -- it gets you on the edge of your seat. Some players just make things happen when they're in, e.g. KP, Freddie, Symonds, Afridi. The sweep and hook are certainly exciting shots, but they're seldom stylish.
Boringness -- not the opposite of style, or of excitement, but the absence of both. Atapattu and Richardson are classically boring players. Think back foot defensive or running it to mid-on for a single.
Some batsmen just eke out the runs without playing classical or exciting shots. The guys like Collingwood and Waugh. The guys who play percentage strokes to most balls -- no fishing outside off-stump, but no exquisite cover drives either. They're not necessarily boring, but they'll certainly not be exciting or stylish.
Of course, it's all grey areas, and circumstances can dictate matters -- even the most boring batsman in the world could keep you glued to the TV set if 10 runs were needed from the last over of a Test match with one wicket left and a rabbit at the other end. Likewise, even the most stylish player could bore you to tears if he's trying to bat for two days solid in order to save a Test.