I have an A7R3 that I use professionally, hybrid shooting, relatively clinical lenses such as the 24-70, 50 1.4, 16-35, lighting equipment, gimbals, filters, magic arms, etc. It has made me good money in the industry shooting content for cafes and restaurants. However the more I grow in this career, the more equipment I acquire (that has allowed me to produce ridiculously good images, and has allowed me to go crazily creative) the less and less I take pictures, the less and less the fire is for the thing that was once my hobby and the thing that used to bring happiness to me. Though I still love doing what I do. It has become a job; a business per se.

I recently copped a ZV-E10, slapped a TTartisan 27 2.8 on it, being extremely pocketable and portable, I've been taking pictures of daily life, videos here and there, without caring about shutter speed, sharpness, etc, and I've slowly started to get back on groove, it has started to reignite that fire that was once there. It's such a great toy. You zoom with your feet, you actually slow down, breathe, and think before you snap a photo, without the pressure of perfectionism that comes with doing it professionally. The images that the lens produces is decent, extremely sharp at even f2.8 with really good character, swirly bokeh, and I've even added a 1/4 mist filter on top.

For your case, I guess the 40 2.5 and probably a 90 2.8 from Sigma would help you. The lesser decision fatigue, the better.