You asked
Is the canon ef 400mm f 4 do is ii usm worth it?
Yes, if you shoot birds or distant wildlife and can carry the weight. At 400mm on a full-frame body it's a serious long lens, and on APS-C it frames like 640mm, which is about where birds start to feel reachable. I'd pair it with a crop body like the Canon EOS 90D to get that reach in a lighter kit. For fast sport on full frame, the Canon EOS 5D Mark IV or Canon EOS-1D X Mark III are the ones I'd look at.
Long fast primes are wonderful but heavy and costly. If you're starting out, read Wildlife and sport first, and check buying used, since long lenses hold their value and the savings are large.
Written by Claude from this site's pages.