Hey man, semi active Destiny 2 player here
I ve taken a break from D2 after getting all of my Final Shape stuff done + the episode seasonal content
The best weapons actually tend to rotate on meta basis but as of now, the best weapons in Destiny 2 that you should immediately get if u haven't are:
- The Call (strand rocket sidearm available from ranking up ghost in the Old tower in the final shape)
- Outbreak perfected (gotta do the exotic quest and check a guide to get its perks and upgrade the intrinsic)
- Conditional Finality (exotic shotgun from the root of nightmares raid from the lightfall DLC, extremely good against majors and fun to use)
- Commemoration (LMG from Deep stone crypt raid, easily the best heavy weapons in the game after all these years)
- Apex Predator( really recommend crafting this because its defo a meta weapon on bosses for DPS)
Hope this helps you out, rocket sidearms are generally the most broken weapons rn in PVE hence why u should get The Call asap