I'd like to study 1 year full time MBA and need a general advise. I have 10+ years of work experience in a big company (so my CV is already not bad), but don't have a business degree. So my goal is primary to gain business basics foundation to accelerate my career and shift the next role into more commercial direction. I'd prefer a study with presence hours (or hybrid online/in-person) that's why Berlin is in the short list.
Is it worth investing into well known expensive MBA programs, or would smaller school MBA (SRH, Steinbeis) work as well for my goals? Or is it better to go for accredited online MBA from the UK for example?

There are many different commercial directions.  The issue with Steinbeis isn't that it's small, but that it's not very good. If you want a classic MBA role... Well, there are not  many of those in Berlin.