OK, I'll dangle my toe in the water...
naitsirch, I'd look to painting a patch *pumpkin* and or leaning to the more realistic. As far as the look goes, I can produce anything you like at anytime with Photoshop and different Styles both Layer/Text and Object which will look as good or better than most Aqua, Candy, Glass, Plastic style you like.
Adobe Exchange has loads of them if you can not create the Styles yourself. Make a shape, any color you like and click a style and bingo you've got the deed done.
I am not trying to take anything away from anyone, and the icon work that comes from some of the people here and on the web is fantastic and I love it. But if you can draw and or paint, don't cover it up with affects and let your style be submitted and accepted on the merits of your abilities.
Also, private is key to this type of question because you do not put people on the spot and they in turn do not have to face popping anyones ego, feelings, ambition, etc...
You know, looking at it...
You could take and shrink it down to say 250x350 (the pumpkin) and get ride of the extra stuff, do it as line art with a fading glow to black starting at say orange and out to yellow into black, say about 15 pixels out from center, make the center orange/red, lay a light fog of purple over that, do some typography design and affects on that(those) layer(s), do some edge work coming out of one of the lower corners that is like a dark scroll work(the vines) where you can just make them out, but only make them reach about 1/5th up the side and bottom edge toward top and the other side. Then on the top opposite side do the same thing and make them the same size leafs and vine diameters but make them reach twice to three times as far and take the top all the way across and drop it over the edge like it is hanging inside a window frame. Then put together or hunt up some icons, do some objectbars for it and your good to go for Hallow Weenie
Or just a Wall that others can add to something they are working on.
anyway, just kicking ideas is all..