Donna Leon’s Guido Brunetti mystery series. Brunette’s Cookbook was written to help satisfy readers who wanted to try dishes that were described in the books.

Redwall. Look at @RedwallFeasts on twitter

Sweetbitter; Heartburn; Family Happiness

Jane and Michael Stern, who write the Roadfood guides, wrote a memoir called "Two For the Road" about their adventures. It's a fun read and they describe the restaurants and food.

I think you have to read Kitchens of the Great Midwest!

Oldie but goodie - under the Tuscan Sun

The Kat Holloway series by Jennifer Ashley. It's historical and set in London. The main character is a cook in an aristocrat's house. I'm not a huge foodie and I love reading about the things Kat makes. The author must have done a ton of research.

https://www.goodreads.com/series/170230-kat-holloway-mysteries

Anthony Bourdain, a Cooks Tour

Louise Penny has great descriptions of meals in her Inspector Gamache series.

I enjoyed the three mysteries Phyllis Richmond wrote shortly after she retired from the Washington Post. She gave excellent descriptions.

Chocolat
Babette's Feast

I was going to say Kitchens of the Great Midwest. Also, Sourdough and Crying in H Mart.
Beverage? The Lager Queen of Minnesota.

Black Cake

Save me the Plums - Ruth reichl
Kitchens of the Great Midwest

I was going to say Farmer Boy! That was always my favorite growing up. Anything by MFK Fisher.

They don’t have to be food-related, but have tantalizing descriptions of what the characters ate.

Eg Farmer Boy by LIW - all of the holiday feasts!