In my mind, local food is more about the economics of supporting small businesses in your community. Sure, eating beans and lentils shipped across the world to your closest whole foods may have a smaller carbon footprint, but your money is still being siphoned to the big businesses in that supply chain.

I consider the money I spent installing solar panels on my house an investment. My electric bill is less than $10 per month. If the stock market tanks, my electric bill will still be less than $10 per month. I helped support a local solar company and a solar manufacturer.

For investing, I use https://fossilfreefunds.org/ to help screen funds. Like you ate discovering, “ESG” is a broad term that gets slapped on a lot of things that may not fit your definition.

Sphere is one fund in particular that uses their voting power to try and steer the companies whose stock they hold away from fossil fuels.