This is the opening scene at the Magic Kingdom...at Halloween. If you want to know what it looks like at other times of the year, imagine it without the Mickey pumpkins. How cute and whimsical is this? Basically there's not a lot to do down Main Street besides stroll and spend your hard earned money on crap you don't need.
Now, Main Street U.S.A. is one of the best places in the world to witness a toddler (oh hell, you might even see a grown ass teenager) meltdown. My favorite is at nighttime when the street vendors are selling things that light up for $50 and the kiddies go nuts! And let me tell you, if you are a parent, bringing your child to the WDW, you better reserve moneys for something that lights every night of the week. Either that or avoid the parks at night. If you don't buy your kid a light-up toy before the fireworks show, they will scream. Believe it! While I think it's fun watching these meltdowns, I'm told others find it annoying.
So, Main Street gets a 3/5 from me. It's got ambiance, but is basically just a huge toilet for your moneys.