There is a very interesting web site
here that discusses various weapons and their applicability at length, and it also happens to focus on game design and game design principles in other sections. An invaluable read before people start spouting various alternative systems to implement how they think things should work. I heartily recommend taking a good, long look.
Edi