Modern wireless mice like the Razer Viper V3 Pro and Logitech G Pro X Superlight have virtually zero latency compared to wired. Go wireless for freedom of movement. The only reason to go wired is if you never want to think about charging.
For FPS games, lighter is better — sub-60g mice allow faster flicks with less fatigue. For MMOs and productivity, 80-100g can feel more controlled. Most competitive FPS players use mice between 45-65g.
Most competitive gamers use 400-1600 DPI. Higher DPI is not better — it is about finding a sensitivity that gives you precise control. Start at 800 DPI and adjust from there.