I have a Minolta Zoom 110 and and an Olympus Infinity Stylus. The stylus has a sharp 35mm lens with a max aperture of 3.5 that's pretty fast for a point and shoot (picrel) and the going rate online is over $100. The Olympus mju II is the successor to mine and goes for about $350 because it has a faster max aperture of 2.8 and weather sealing.
Apparently Kendall Jenner appeared on a talk show a few years ago and talked about her Kontax T2 and now those go for $1000 used. The Kontax is a fantastic point and shoot though because it allows for aperture control and manual focus and has a very sharp lens. It's compact and is made of metal not plastic. Are these cameras good? Yeah they take great photos. They're overpriced in the current market though though. That's why anons coom themselves when they see one for sale at Savers for $5 because the staff assumes they are just a shitty 90s camera.