Welcome to the forum!
This depends on what you want to photograph. Plants? Birds? Spiders?
I have a Canon PowerShot ELPH since over a decade ago, and it occasionally misfocuses. I’m up to 2084 photos, and because of the filename format, I don’t know what it’ll do when I get up to a myriad.