Source: the in-game weapon menu

What Is the Best Weapon in GTA 6?

For raw damage, the Hauners H-AT rocket launcher at 9.6 out of 10. For everyday work it depends on the class:

Assault rifle: the AdB FRA, 5.8 damage and 6.9 range. Tactical rifle: the Hillinger M306 TMR, 7.8 accuracy. Sniper: the Fairview FF-50, 8.5 damage. Shotgun: the double barrels hit hardest at 8.0, the Mason & Keen Longshot and Shrewsbury Drifter. Pistol: the Fairview Kalinga .50, 7.0 damage. Revolver: the Scorpio Akulus, 7.0. SMG: every SMG does 4.2 damage, so handling decides it: the Vom Feuer VF5C and the VF5.

Most of the heavy hitters sit in Expanded stock, so they are not at every Ammu-Nation. All 53 standard guns, sortable by every stat, are in the Full Arsenal.

What is the best starting pistol?
The Girardi ES9 is the most accurate of the standard pistols at 5.2, with 15 rounds. The Klose K17 holds 17 and handles slightly better.
Source: GTA VI, in-game
Which machine gun hits hardest?
The Goodwin LMG 6 at 6.8 damage, with 100 rounds and poor handling.
Source: GTA VI, in-game
Are unique variants better?
Some are. Variants carry their own tuned stats, some above the base gun, but they cannot be modded.
Source: GTA VI, in-game