I was able to get a really good deal on a second-hand a6700 that seemed barely used when I got it. It's definitely not small enough to put in a pocket and it's still too expensive not to baby. It's amazing for video and I love the sony color science (controversial). I use it for work as well as if I feel the need for media that has more flexibility in post.

For "I'd like to remember this event" type photos where resolution and accuracy aren't the priority, I usually just bring along a disposable-looking plastic 35mm camera I can just toss in a bag and hand it to friends/family if they want a picture. Unfortunately, a lot of these kinds of cameras seem to be inconsistent. I had a Kodak Ektar camera and the film advance wheel broke within a week. I also have a Ricoh RZ-900 I got from the thrift store and a bag of expired unused fujifilm rolls for $20. It's not a great camera (and I suspect it will die soon since the motors sound very bad), but it works for what I need it to do.

The weight isn’t all that bad. I’ve been running around with it all day on vacations and wasn’t bothered by it. The size imho is more important. I paid ~1400€ used. All the cameras with interchangeable lens systems are in similar price ranges unfortunately. The more compact ones are even more expensive. There is a very compact sony one with integrated zoom lens i forgot the name of that goes for more than 2k€ The ricoh gr iv is similarly priced and has a fixed zoom lens and no EVF and in sunny daylight no evf is a no go imho. The displays on cameras are usually much darker than smartphone displays so you really need an evf.

If you want to safe a bit of money you can go for the a6400. it has a couple of compromises but isn’t all that much worse purely for photography.

But yeah cameras are expensive. But they last you much longer than smartphones and the retail price is fairly stable. There is 10 year old ones that still go for a significant chunk of the original price on the used market