Would a really great resume done up in Comic Sans be more of a turn-off than an eye-catcher? This is not a joke question (at least that's not the intent)
BUT, if I got the same resume out of the blue without already knowing what kind of person you are, I'd toss it to the same pile as the other rejected resumes without even reading it.
Although in the right circumstances, it could be hilarious... but you need to be already in a position to control the lead of those circumstances.
Instead, I'd use the most current modern-looking and serious font I could find, and make it visually amazing.