Can you please give me some example of good written, but transparent evil story? O_o
Prince of Thorns Hannibal American Psycho American History X The Talented Mr Ripley Richard III Dexter Strangers on a Train Lolita The Lies of Locke Lamora
.... just off the top of my head.
In pure fantasy settings, Raistlin from Dragonlance is a superbly written evil player character, as are the cosmic representations of good and evil in the entire Dragonlance universe.
What makes characters compelling, good or evil, is the conflict they encounter AS A CHARACTER that allows for dynamic growth. For evil characters, that means grappling with the consequences of their actions in whatever way allows them to continue pursuing their goals. Evil protagonists are often their own antagonists.