As a German: you are exactly right. Sitting down at the Stammtisch is asking for trouble. It's reserved for the die hard locals - it's coming from Stammkundschaft which roughly translates to regulars. Still it's perfectly fine to sit next to it or somewhere else in the bar. Usually sitting directly at the bar is the place for newbies or foreigners and people are often willing to talk and interact. Sometimes the bar keeper is interested in having a conversation or someone ordering a few beer initiates a conversation and invites you to their table.
Unfortunately my experience (in eastern Germany, maybe it's not universal) you tend to meet lot's of broken and fucked up people in bars and very little normal ones. At least I seem to have a talent to attract assholes and fascists that tell me their world view after a few beer. But this depends on the bar and the area. It's not all happy happy live.