For the past 15 years or so, I have been using the Canon PowerShot point-and-shoot (“point-and-hope”) cameras. I have been very pleased with the results for insects. I currently have an SX620 (several years old; starts at about $300) which is excellent for moths, small bugs, etc. I also use an SX740 (newer; about $450) for most daytime photography. The latter camera has a 40X zoom which can be useful for butterflies at 10 to 30 ft away or birds up to 50 to 100+ ft away. Here are links to some of my recent insect images and bird images:
Insects: https://www.inaturalist.org/observations?d1=2023-06-09&d2=2023-06-15&place_id=any&taxon_id=47158&user_id=gcwarbler&verifiable=any
Birds: https://www.inaturalist.org/observations?d1=2023-06-09&d2=2023-08-03&photos&place_id=any&taxon_id=3&user_id=gcwarbler&verifiable=any
Note: I do a lot of serious cropping to focus on the subject insect or bird; in the original images, the critters are usually much smaller than what you see in my upolads.