I just finished mine last night. I did one of those elaborate designs that looks semi-professional, and boy, is it cool!
My secret weapon?
A Dremel Rotory tool. What a job it does on fine detail. Little messy, but after you finish and rinse the pumpkin out, it looks mighty fine, and there is little risk of breaking the picture with a knife.