If Deep Rock Galactic counts, then Monster Hunter games should as well. The hub is usually a bar/restaurant with food, drinking, and an arm wrestling mini game. You can also randomly cook meat out in the field or go to hot springs.
Many other games do have bars, but without any real interaction. Lego games and Borderlands come to mind.
Stardew Valley has cutscenes at the bar and you can play a mini game there, but not quite as interactively as DRG.
That’s all I can think of right now. It feels like Baldur’s Gate 3 or Saints Row should also have something similar to Stardew at least, but I can’t remember how much you can do in those bars. Same with MMOs I haven’t played in a while like Runescape. I’m sure if I mention them someone else will know though.
As a bonus: with modding, Lethal Company can have a casino with a bar you can get drinks at.
Unlikely to be it since it’s nowhere near from the last 10 years, but CITY 2000 seems like it could be similar at least artistically?
I think the best I can recommend is looking through Steam, searching for “London” and the mystery genre. I didn’t quite catch anything there that fit at a glance, but maybe you will. Similarly could be done on GOG, since it sounds like it could potentially be an older game? Or itch, but maybe the best way to search for that would be by googling
london missing friend mystery site:itch.io
.I’m assuming a modern setting, with no supernatural elements and the mystery genre, so that’s the best I could do. It’s going to be very hard to find something without some details being fixed. Point and click? Photos or isometric? Is the player character visible? Do they have any identifying details? Does the pub have a name? Anything like that could do a lot.
You say you watched someone play it on youtube then you might be able to search your youtube viewing history?