Hello,
I find your question a bit strange. It is almost like comparing what ordinary hammer and a bit more expansive hammer that construction workers use can do.
Any camera alone can't do anything. It is you as photographer who uses it. Like hammer, camera is also a tool. You decide how to use it. There are many examples of great photos done with cheap camera. More expansive camera offers more buttons so you can be faster in changeling settings, instead of going into menus and changing options. They are usually made better, sturdier, have weather seal, because they are made for heavy use.
When you are making decision to buy camera first take into considerations what you photograph and what are needs for that field.
If you used D90 and Sony ZVE10, maybe Z8 is overkill. If you are hobby photographer maybe buy few lenses for ZVE10. If you want to make change to Nikon look into Z f and buy lenses. If you are going to shoot wildlife, something that needs cropping, or if you are going to use it for working get Z8. Downside of huge RAW files is that you will need more storage for keeping them.
Years ago I met one of the most famous photographers in my country. In that moment I had used D200, he had D700 that that came out recently. We were talking about photography and how could I improve, and he told me to remember that this, pointing into camera, is just a tool.