You asked

Is the sony fe 400 800mm f 6 3 8 g oss worth it?

It's worth it if you mainly shoot birds and distant wildlife and need every bit of reach. It's Sony's longest zoom, and 600mm and beyond is where that kind of photography starts. The catch is the aperture: f/6.3 to f/8 is dark, so you'll want good light or a body that copes well at high ISO.

On full frame, the Sony a7 IV is a sensible all-rounder to pair it with, and the Sony a9 III is my pick for fast-moving subjects. On APS-C, the Sony a6700 turns it into roughly 600-1200mm in a body you can carry all day.

If you mostly shoot sport or animals closer to hand, a shorter telephoto zoom will feel far more usable. The Wildlife and sport guide covers the reach you actually need, and Sensor sizes explains why APS-C can be the smarter choice here.

Written by Claude from this site's pages.

From these pages