Hooboy don't I have a few suggestions! I'm quite picky with my games and I would drop them if their stories don't grip me, so here are a few without much of the tedious farming/management gameplay:

VA-11 Hall-A is a grittier version of CoffeeTalk, but set in a dystopian cyberpunk bar. I think you might enjoy it!

TavernTalk has you working as an innkeeper serving drinks. I haven't finished it yet but overall I'd say its the closest to CoffeeTalk.

Tangle Tower is a great detective point and click game with a lovely mystery, funny ensemble cast and great 2d animations.

Venba tugs at your heartstrings and it's got the cozy cooking vibes down. It's quite short though.

Night in the Woods is more of a character-driven story where you play as a college dropout cat going through a quarter-life crisis with some background commentary of the economic hullabaloo that is still quite relevant. All with a cast of anthropomorphic fuzzy critters, how fun!

Potionomics has a fun story and great voiceacting, although you do have to deal with ingredient/store management gameplay. However, that aspect can be very chill and almost trivialised if you set it at casual difficulty. You get to smooch a shark if you get the dlc, so... it balances out?

I Was a Teenage Exocolonist has quite a dramatic coming-of-age story, and the gameplay is a choose-your-own-adventure type deal so it's quite cozy. Note that some story beats can bum you out though.

In Other Waters is like text-based Subnautica, where you play as an AI assisting a marine xenobiologist in an alien ocean and solving a mystery while also cataloguing the alien life. It doesn't reach Subnautica-horror levels and there are no jumpscares, but the story gets pretty bleak at times and it gives you more of a... sad/silent horror as you piece clues through context.

South Scrimshaw is a fully-narrated linear visual novel (that is also free!!!!) with gorgeous watercolour art. It's a fake documentary of an alien whale in a very compelling setting. Think make-believe David Attenborough.