While I do find some of the helmets and outfits to look goofy, I actually like the constant changing of armor. It makes me think of Vikings and such, a fitting throwback considering the fantasy setting. Watch a film like The 13th Warrior and you'll see one character with a Spanish helmet and completely mismatched studded armor, while another has a thick fur while donning a French helm. Granted it all looks practical in terms of warfare, unlike the Dalish armor on females, but it gives this feeling of "I've been anywhere and everywhere". Which is how an adventurer should feel.
That said, I think the most goofy aspect of changing outfits was the constant fluctuation in cup sizes on the females. I'm typically not one to ogle a 3-D model, but I swear Leliana went from a D-Cup in her conservative robes when I first got her to a C when I put her in leather armor. This change occurred for Morrigan rather often as well.
I wonder if it would have been better for them to try and fit the armor model over preset character dimensions or not?
Actually, plate mail tended to look more odd on non-dwarven characters as well. The huge shoulder pads somehow fit for the dwarves since they are so stout, but when I put some on Alistair and Sten it looked really awkward. So wide up top, but then so scrawny at the legs.