This is a reasonably up-to-date sheet of Rimworld firearms offering a lot of detail, and breaking down all their statistics to calculate a weighted DPS per range band, with color coded weights for quick comparative analysis.

It currently includes most weapons from the Core game, Rimsenal Core, Rimsenal Federation, Crystaloids, Ratkin, Vanilla Expanded, and Vanilla Lasers.

https://docs.google.com/spreadsheets/d/1h2tKxljGuBdDWoDIso-UXcZ_CNYP3_LfRvleR5q-LPA/edit?usp=sharing

The current 'ultimate' weapons across all these expansions within each range band in terms of outright DPS are:

- YP Dual Shard Pistol (Point blank)
- YP Shard Rifle (Short)
- TE Kinetic Lance (Medium)
- Modular LMG (Long)
- JI AMR (Extreme)

In my anectdotal experience, the TK Lance is the deadliest weapon in the game to date, capable of reducing entire groups of enemy pawns to mush in a matter of seconds, or endlessly suppressing large targets like centipedes, rendering them functionally helpless while nicking them to death with its incredibly long bursts. Its 1 square AoE renders it even more accurate than its already high accuracy values suggest.