Are you looking for unique and modern pumpkin ideas? But if you are more into crafts and DIY then these painted pumpkins are what you crave. You can also check Martha Stewart's website, they always have great tutorials and ideas for holiday celebrations.
I bought some squash and pumpkins at Whole Foods and just placed them on the dining table. Bare. No frills, and they actually look good. See for yourself.