>>3089970There is always going to be a big trade-off in performance, size and zoom range. When you consider the tiny sensor inside of the P900 and it's low resolution of just 16mp, it's no problem to design a lens with such a long zoom that just barely meets the criteria for rendering an acceptable image.
That's not to say only shitty cameras can have a large zoom range, when cost is no object you can get similar to pic related, which in this case is an 86x zoom lens for broadcast use, although there are ones that go up to 100x as well. The trade off for having a pristine image at any point of its (equivalent) zoom range of 35-3000mm is a monster that costs $200,000 and weighs 24 kilos.
Dialing things back to more reasonable levels, the "sweet spot" for most zooms is up to 3.3x, which is why most "professional" zooms cover ranges like 24-70mm and 70-200mm. Ranges of 5-6x already begin to compromise on some aspects, and 11x lenses like the 18-200mm are called super-zooms and generally have poor performance near the extreme ranges of the zoom. Anything more would simply be prohibitively large and expensive if you also wanted to maintain sufficiently low distortion and a sharp image for larger sensor sizes.
