'New' is mostly irrelevant, in terms of digital cameras. Granted, you won't have warranty support. Nor, the latest brag rights on UHH. And, the older the model, the less likely of a repair option. But, modern cameras, say anything from 2015 onward, are luxury goods. Few 'need' can interchangeable lens camera. Lower-end models compete with $1000 phones, so who needs a $1000 camera-phone and another $800 camera-camera? As luxury goods, this equipment is built for the long-haul, where 'used' is typically indistinguishable from new in the equipment's long-term useful-life-expectancy.

Since you refused to provide the requested details to give focused answers, consider the Canon Powershot models, that are all 'new', 'digital' and 'sub $800'. I shoot with an older Canon G9X-II, a 20MP model, where Canon and Sony have standardized on this pixel resolution and cropped sensor for their multiple models in this pocket-sized model. Sony's version are 'Cybershot'.

For interchangeable lens cameras, you just have to consider your options. A widely popular model like the Canon EOS 5DIII now has a glut of used models in the resale market. They're appearing lightly used in the $600 range, for a 22MP full-frame camera with many of the features of Canon's top 1DX-II model from the same 2012 time period. Any 20MP to 24MP model is much the same as another, whether new or 10+ years old. Worrying about 'new' is your own self-limiting decision, and worrying about sub $1000 is unrealistic for 2023 -- probably forever more.