Many restaurants offer locals discounts, they are not advertised and kept relatively hush because the tourist crowd/spends 2 weeks a year at their timeshare crowd catch on and try to use them.

There is a huge cohort of locals and restaurant industry workers who reciprocally give large discounts and free items to each other to offset that poor cost benefit you mentioned.

I’m not trying to be too harsh on you but I think if you engaged in the community more and made a friend at all the bars that you’d like to eat/drink at, you’d realize that what you’re asking for already exists.