First off, I think people should throw whatever they want to throw. Experimenting is the spice of life. Have fun. Buy every disc imaginable and see what happens.
But, there is no magic. If you throw 225' with xyz disc, there is no disc that will turn that into a 300' of 400' or more.
Consistently. The most evil things discs do is the unexpected. They fly 100' further than they should. Once.
Like golf, DG, is a mental game as much as anything. I have and continue to try to unlock the magic...nose down, light weight discs, perimeter weighted discs, etc., but, at the end of the day, it will be the archer and not the arrow that determines success. Even if you find the disc that does something special for you, it will be you that makes it happen.
If you could throw 400' in a shotgun pattern versus 200' with pinpoint accuracy, who would win on a given course? More often than not, the 200' ACCURATE thrower. The issue is the 300' semi-accurate thrower, and most of us are not PINPOINT accurate at 200'. Of course in wooded/tight lines, those numbers may be a fraction. Being 50' out in horrible rough sucks more than being 200' out in the open.
Golf success starts with minimizing bad and going from there. IMO.
Mambas, Beast, Grace, Saint, Ballista's, etc., all offer a lot of promise. IMO, the Hatchet gives the most bang for buck if you find the right disc. Don't push it. Let the Hatchet do the work. Probably never going 500', but it can stretch a casual 250' to 300' or more (IMO) like no other.
Throwing hard is generally the antithesis of gaining distance. Every extra bit of force is lost to poor form (nose angle, OAT, etc.)
As Danny (dynamic discs) says, slow is smooth, smooth is far.