Hey dude, whether or not a weapon is good realistically depends on your perks, I have made my character proficient in only pistols and melee weapons, so no matter how "good" a rifle may be, it won't even come close to a pistol in my hands, decide what kind of weaponry you want to use, pour your points into perks that affect that weapon type, and you will see that most of that weapon type will be useable! I recommend a sneak/sniper build for efficiency, but any build you choose will be more than fine!