Lanefan
Victoria Rules
Blame to which I would, if in this situation, proudly claim ownership.But ppint is that the DMG tells you to determine the type of weapon or do it randomly. However to my knowledge there no table to roll for weapons. So it's up to the DM to screw over the Fighter.
If you are a greatweapon fighter and your DM gives you a +1 sickle, the 100% on the DM.
The treasure in any adventure, be it homebrew or pre-published, is determined and placed long before any characters get there and without prior knowledge of (or caring about!) who-what those characters might be at the time.
So if you're a 2-handed-sword user and the magic weapons in the treasury consist of a +0 flametongue mace, a +0 shortbow of double range, and a +1 sickle, then so be it: you're SOL. Take that stuff back to town and hope you can trade it in on an enchanted greatsword.
Maybe the next party I run this adventure for will happen to have an archer and a mace-wielder in it. Maybe not. Again, so be it.