I believe Comic-Sans is not good for anything... comics included.
Of course you can change font settings, like kerning or tracking and make look less like Comic-Sans, but it will still look a bit odd, I think.
I struggled with this for some time because most of the fonts I like are really hard to apply to comics and keep them readable.
I had a moment when I made dialogues by hand, but it resulted time-consuming and hard to deal with when I needed to correct something.
What I finally did - and I think it looks the best - is I used http://www.yourfonts.com/
to create my own font. It is really the easiest way of creating your own font (compared to other programs I found).
This way, in my opinion, has another big advantage: your font is really yours. What I mean is that every comic style is a bit different and so is the
font which should be in accord with the drawing style. If your style permits, you can even use Times New Roman.
More on the subject: