Lighter shoe = less stability and possibly less support. Also less longevity.

I mean it’s mostly a question what you’re comfortable with. Personally I have been using trail runners for everything but high mountaineering terrain, so take a look at Salomon/ASICS/Brooks. If you want waterproof just buy a pair with gore Tex.

Alternatively you can go with an approach shoe, those are a bit sturdier/stiffer but are still relatively light and have a climbing notch that comes in useful on light/medium terrain. Usual brands are Scarpa/La sportiva/Hanwag

You can’t buy beer on a Sunday? German beer riots used to be serious business btw: 20 people died in riots 1873 because beer prices were set to be raised in Frankfurt.