Holy crap... what's with you guys saying Bug? If anything, this type is one of the best types in the game.
1) "hey've got like Bug Buzz, Megahorn and X-Scissor, but that's about it move wise. "
U-Turn? Sticky Web? FREAKING QUIVER DANCE?
2) "most of them are frail - most especially the dual typed bugs."
Scizor has good bulk (70/100/80), can mega evolve and become an excellent tank, and only has one weakness. Heracross can also take a hit or two unless that hit deals super effective damage, can once again mega evolve, etc. Volcarona also tanks special attacks quite well, especially after one Quiver Dance. Scolipede can also depend on its bulk (especially with Iron Defense, which is one of the main reasons the move Baton Pass has been nerfed) to set up and pass a Swords Dance boost to a powerful attacker. And finally, Genesect has loads of resistances just like Scizor and thus it can take many hits, but it's much faster, can use Download to awesome effect, and has an incredible movepool (which is way it was ultimately banned).
3) "Also, Fairy resisting Bug was like kicking a person while they were down on the ground."
Most Bug-type Pokemon can actually get past Fairy-types with their coverage moves, or their other STAB. Scizor once again comes to mind, since unless said Fairy-type is named Azumarill or runs HP Fire, it thrashes them with a simple Bullet Punch for a 2HKO or even an OHKO. Mega Pinsir can set up a Swords Dance and destroy them with an Aerilate-boosted Return, while Mega Heracross can also defeat them with a Poison Jab, which is usually enough to kill since this pokemon has a huge base attack. Volcarona resists Fairy and can use most fairy-types (bar Azumarill) as setup fodder. Shuckle and Venomoth can set up for free on Fairy-type Pokemon. Scolipede can also set up a Swords Dance and OHKO fairies with +2 Poison Jab.
You guys are underestimating this type. This type provides much utility with U-turn and most Bug-types have access to boosting moves to potentially sweep. Remember the king of Gen 5 OU? Yeah, it was Scizor, who is a bug-type.