Actually Yuffie's Shurikun isn't too oversized, although Squall's gunblade is ridiculous.
You're forgetting time period, in order to make a detailed weapon in FFVI they had to buff up the size of the image.
Why?
Simple, people dig huge weapons. They found that out when Sephiroth and Cloud got all of their fans and now their milking it for all its got.