The Doors are awesome. At their best, they provided slightly insane lyrics that explore the darker side of the subconscious and succinct guitar lines that float over waves of ethereal keyboards.
It's hard to explain.
Their debut album lays it all out: you've got some blues, some psychedelia, some pop (later albums emphasized one of these over the others--Strange Days, for instance, is mostly psychedelia, Waiting for the Sun is mostly pop, Morrison Hotel is mostly blues--but the first album is the only one where they fused it all together brilliantly).
Since you also don't dig Led Zeppelin, maybe you just don't like white boy blues?
And like cujo said, if you want to see what makes a band special, listen to the albums and not an overplayed greatest hits compilation or, God forbid, the radio.
and 
.. get bored very fast.
good luck with that one around here!
the beatles, but i understand)
...
