These are what we call the 'YMMV items.' Things that some people find in this work. We call them 'your mileage might vary' because not everyone sees these things in the same way. This starts discussions in the trope lists, a thing we don't want. Please use the discussion page if you'd like to discuss any of these items.
Awesome but Impractical: The Cavalier class. A quite literal example of a Prestige Class, you gain a combination of the Fighter's ability to use any weapon, a number of the Cleric's utility and healing spells, and the ability to declare a weapon you are wielding as a Holy weapon. So what are the requirements? You have to be a Noble, of lawful alignment, must stay true to the cavalier's code, and have to sacrifice every level and ability unlocked of the class your Noble character is, to become a level 1 cavalier, and have several additional garb/armor restrictions applied to you. Most players who didn't attain nobility as a fighter, tend to skip the option and remain their original class.
Some of the Yellow (bludgeoning) weapons are this. Sure, a great hammer is big, and intimidating, but it will still never be as capable or easy to use as a sword, or a bar style weapon.
Boring but Practical: The "White sword" weapon color class, which includes short and long swords. They'll probably be the first weapons you'll ever use when you join Darkon, thanks to restrictions that prevent players from using two handed weapons, and ranged weapons for their first 5 and 10 events respectively. They deal minimum damage upon hitting a foe, and just about everyone can use them minus clerics. They are also amongst the easiest to use, can typically be swung quickly, work with many different weapon combinations and players fighting styles, and can be constructed with a "Stabby tip" to thrust with them for Red (armor piercing) damage.