This trope basically comes from a combination of Rule of Cool and Bigger Is Better. An oversized sword is a unique weapon that will stand out from the crowd, and marks its wielder as a person of above-average or even superhuman strength. Many writers like for their protagonist or villain to be as cool and unique as possible. As for its usefulness as a weapon, most people assume that a bigger, heavier weapon will inflict more damage on whatever it hits, provided that you can find a person strong enough to wield it. Force equals mass times accelleration, so if you swing two weapons of different masses at a target going at the same speed as each other, then the more massive object will hit with more force. However, people might fail to consider that oftentimes it is more efficient to increase the acceleration of the weapon than to increase its size. Modern rifles using energy efficient smokeless propellants shoot smaller bullets at higher velocities than their black powder ancestors, which combined with rifling gives them more accuracy, range, and penetrating power despite not increasing the weight of the actual projectile. To continue this comparison, when you're talking about a gun, the propellant in the cartridge case and the firearm in which the explosion takes place are what propell the projectile, while when you're talking about a sword, it is the human and his or her muscle power which accelerate the projectile. Unlike designing a gun cartridge, where if you create a more powerful cartridge then you can design and manufacture a new firearm whose breech and barrel can handle the increased pressure of a stronger cartridge, you cannot create a bigger sword and then design from scratch a human who is big and strong enough to wield it. And also unlike with guns, where a gun too big to be fired from the shoulder can still be used as a crew-served weapon mounted on a tripod, gun carriage, or vehicle, there is no use that can be found for a sword too big to be wielded by a single warrior. Therefore, sword design has to take into account what the average physically fit human warrior is capable of. Sheer weight or mass is not by itself a good thing; you need to make the sword just heavy enough in the right places to do the job intended, without getting to the point where the mass is just slowing you down and robbing your strike of energy. Generally you can make a blade big in one or two dimensions, but not in all three dimensions at once. Some swords such as the Chinese dadao or Philippine panabas have very short, very broad blades and long two-handed grips in order to get a lot of chopping power like a meat cleaver at the cost of short reach and having a not-very-servicable point. Medieval cutting-focused greatswords would often have a long blade that was broad along its entire length (in other words, little profile taper) so it would have both reach and cutting power as well as a broad point that would do pretty well against unarmored or mailed opponents, but had an aggressive distal taper, meaning that the blade was thick near the guard but got progressively thinner towards the tip, keeping it from getting too heavy towards the point but making it less suited for penetrating hard targets or slipping through the gaps of plate armor with a thrust. And then there's the rapier or estoc, which sacrifices most of its cutting ability for point control, reach, and penetration: The blade is very long (for reach), has a thick spine along the entire length (for stiffness), an accute point (for penetration), and a narrow profile (also to help penetration, and to reduce the weight). There is also more mass in the guard relative to the blade, pushing the center of balance closr to the hand, which makes it easy to manipulate the tip. However, this makes for a far-back center of percussion which reduces the range at which you can make effective cuts, and the thick edge section combined with the light blade reduces cutting power. Each of these swords, despite their differences in handling, are basically agile and maneuverable weapons because they make compromises. When it comes to length, breadth, and thickness, you can pick any two but have to sacrifice the third if you want it to be a handy weapon. What the BFS does is expand in all three dimensions at once, to the point where the overall weight and balance would become unmanageable. Giant swords are impractical in the real world because of the Square/Cube Law, which guarantees that a sword that gets too heavy will be slow and cumbersome no matter how strong its wielder is for a human. The sword has to be a relatively small percentage of its wielder's body weight in order for their muscle power to accelerate and control it at high speed. Even a person who can lift a 200 pound barbell over their head would struggle to use a 20 pound sword effectively, simply because it is a lot harder to swing a weight around your body at arms' length than it is to slowly raise it straight up and down over your center of gravity. Eight pounds is pretty much the upper limit for what even a six-foot long greatsword can weigh before it becomes too unwieldly. Even so, actually wielding a giant sword such as Cloud's Buster Sword would require not only Super Strength, but also a whole set of Required Secondary Powers. An object that large has tremendous inertia, meaning that it is extremely difficult to get it moving from a resting position, and just as hard to stop it or change direction after it gets going. In order to actually exert on the weapon the minimum force needed to accelerate it to the speed of a sword swing, you would have to be able to push off of the ground without your feet slipping out from under you, and then the sword would try to yank you forward along with it when it got up to speed. For that you would either have to personally weigh several times as much as a normal human or artificially increase your personal gravity, stability, and traction using sci-fi technology or magic. Once you were able to swing it and keep your footing, you would also need Super Toughness in order for your bones, muscles, and joints to withstand forces that would normally rip a person's arms off. Many examples of the BFS that were made in real life are simply not meant for combat. An executioner's sword is designed to chop through a restrained person's neck in one swing so that defense and agility need not be considerations in the design, which is why they were made with long grips for leverage but relatively short, forward-balanced blades that usually did not even have a proper point. At least these were usually within the typical parameters for a fighting sword; Ceremonial swords had hardly any constraints on their weight and dimesions, such as Henry V's bearing sword in the Tower of London which was far too big and heavy to use as a weapon because it only needed to look impressive as it was carried in front of his procession. You could say that this latter category subverts an important part of the trope, because unlike the fictional BFS which is made because there's someone who can wield it effectively, smiths of old were under no illusions that their giant ceremonial swords were useful to anyone as practical weapons. Realistic, practical two-handed blades such as the German Zweihander and Scottish Claymore weighed around 5-7 pounds, just over twice as much a one-handed arming sword. Such swords would have a very long grip, which allowed greater control over the blade than a shorter hilt; where a one-handed blade's weight was held steady by the hand and wrist, the longer hilt of these swords turned it into an arm motion and created leverage through the distance between the hands. Such greatswords were not used just for sheer power, but for a combination of cutting power, reach, leverage, defensive radius, intimidation, and versatility. The large dimensions and inertia of big two-handed swords made it difficult to take full advantage of their capabilities without considerable stamina and skill, which is why the Doppelsoldner who wielder the Zweihander in German mercenary armies earned double pay for their expertise.