@darkknightdetective: To be fair Superman is from farm country, that's where the mullet originated and the only places where its still acceptable.
Doomsday is like your everyday villain, he's nothing special or out of the ordinary. He's that one mindless monstrous villain that some heroes have to come up against, that's it.
Because he killed Superman doesn't make the character anymore interesting, especially when he has no character depth in comparison to the likes of Lex Luthor.
I think his appeal lies in that it's the essential roaring monster. Like we've seen Superman take on quite a lot of monsters with no names and appetites for destruction, Doomsday just made a bigger splash and came back for more. DC then kinda screwed it up by making him grow a brain, as shown above.
As for a movie, he could work very well if he is tweaked for it. Like a weapon Luthor has been developing or found to fight Superman that gets released near the end of the movie for another huge battle (instead of trying to make us think a man in an armored suit could take on Supes).