The most attractive fictional characters that are NOT sexy

Hold on, if we're going into 2D, there's specific sub-divisions. We're going to need to narrow this shiz down to deredere, tsundere, kuudere, yandere, etc. GODDAMN.

Explain the difference