I am quite the opposite. When lyrics are weird, mystic and not so obvious there's much more room to interpretation and imagination. I surely don't want him to sing, let's say, about how he's chasing girls or riding a motorcycle. In other words, I prefer Revelations, Powerslave, Taking the Queen, Darkside of Aquarius, Accident of Birth, Chemical Wedding, The Tower, The Alchemist lyrics style, over 22 Accacia Avenue, Public Enema Number One, Fear is the Key, The Apparition, Weekend Warrior, Hell On Wheels, Cyclops lyrics.
You can say that lyrics can be great without being weird. For example, Tears Of A Dragon lyrics are perfectly understandable, but for me it surely falls into the category which I prefer. Allegorical and poetic.