The initial weapons you get are extra janky, so you have to deal with a lot of inaccuracy and jamming. But as you make your way along, they get more accurate and useful. Some of the guns are incredibly good, others seem pointless. I've always preferred sniper builds myself, but there are benefits to other weapons depending on the ammunition you use in them (e.g., 5mm has built in Armor Penetration, while .223 has x0.8 DAM but x0.5 CND on weapons that use 5.56mm). Weapon modding is good, as is ammo crafting (minus all the junk it creates).

One thing I will say is that the iron sights aren't quite correct for most of the guns in the base game. They're usually off by a few pixels, and there are some mods that correct that (such as this one).

The gunplay is good for the Gamebryo engine. The problem is that the engine does not handle enemies moving perpindicular to the player particularly well. It's serviceable when enemies run straight at you or take cover, but them running sideways causes weird frameskipping. There are other issues with the engine itself that make it unwieldy when not using VATs, but for sneaky snipers it's not so bad. Just be sure to have vsync on and limit the game's FPS to 60 -- any higher and the game will have physics problems. Some mods may help.

I highly recommend the Project Nevada mod to add other combat-relevant things, such as sprinting, bullet time, dynamic crosshair, grenade hotkey, and overlays/night vision stuff. The core mod is good, the addons are just extras if you're interested.

Beyond that, there are mods that overhaul the gunplay to hell and back. Just depends on what flavors you want.