I am thinking of a scene in a film that goes something like this:
[Three middle-aged characters are sitting in a diner.]
Character 1: Pie is the perfect food.
Character 2: There's a pie for every mood.  You got pecan pie, cherry
pie, key lime...

Character 2 continues naming different types of pie.  This is a very
rough approximation of the actual lines, but it gets the points
across.  I cannot remember what Character 3 says, but I believe that
this conversation took place with more than two people at the table or
booth.  I am pretty sure this scene took place in a film, not a
television show.  I am not thinking of the scene in Seinfeld that
goes:
George: That's pie country. They do a lot of baking up there. 
Jerry: They sell them by the side of the road.  Blueberry blackberry. 
George: Blackberry boysenberry. 
Jerry: Boysenberry huckleberry. 
George: Huckleberry raspberry. 
Jerry: Raspberry strawberry. 
George: Strawberry cranberry.
Jerry: Peach!

The scene that I am thinking about is similar to this scene in Forrest
Gump (expect it's about pie, not shrimp):
Bubba: Shrimp is the fruit of the sea. You can barbecue it, boil it,
broil it, bake it, sautee it. There's shrimp kebabs, shrimp creole,
shrimp gumbo, pan fried, deep fried, stir fried. There's pineapple
shrimp and lemon shrimp, coconut shrimp, pepper shrimp, shrimp soup,
shrimp stew, shrimp salad, shrimp and potatoes, shrimp burger, shrimp
sandwich...

I'm searching for the name of the film.

I believe the paean to pie comes from the movie "Michael," which has a
delightful scene in which pie is discussed by John Travolta, William
Hurt, and Andie MacDowell (culminating in Andie singing a song about
pie). Here's a transcript:

"What'll it be, folks?

 Do you have pie?

 Do we have pie? You're in the pie capital of America.
 
 Well, we want....
 
 We want pie. What have you got?
 
 I got them memorized, okay? Ready? We got apple, of course...
 ...banana cream, coconut cream, sour cream raisin.
 
 Chocolate cream?

 Definitely. Chocolate cream and strawberry rhubarb pie and 
 cherry and lemon meringue.
 
 We want two slices of everything.
 
 And vanilla ice cream on the side.

* * *

 What is it about pie?

 There's nothing prettier than pie with scalloped edges and 
 slits in the top for the heat to escape.
 
 Pie gives you the sense that you're a square person...

 ...living in a square country.

 A pie says home.

 As American as apple pie.
 
 I wish I invented pie."

Script-O-Rama: Michael Transcript
http://www.script-o-rama.com/movie_scripts/m/michael-script-transcript-john-travota.html

"In the movie Michael, with Andie McDowell [sic], John Travolta and
William Hurt, there is a blissful moment. It is a scene wholly devoted
to pie. Not only is there praise for and the ordering of many, many
pies at a roadside diner, but Andie McDowell's character sings a
country-western ditty all about pie. William Hurt's character falls
for her right then and there, when she ends the song, 'My oh my, I
love pie'."

Texas Cooking: Patchwork Pie
http://www.texascooking.com/features/nov2004pie_recipes.htm

"In the movie 'Michael,' starring John Travolta, a group of people are
seated in a restaurant and they order two of every kind of pie on the
menu. Travolta asks the question, 'What is it about pie?' and he gets
these responses. 'It's pretty. There's nothing prettier than pie.'
'Pie says home.' The waitress, who has joined the group, smiles,
reaches for a bite of pie and says, 'God is in His heaven and all is
right with the world'."

Cherokee Link: Heaven Sent
http://cherokeelink.cherokee.org/Phoenix/XXVIno4_Fall2002/PhoenixPage.asp?ID=59

"Michael" is available on DVD and VHS:

Amazon: Michael DVD
http://www.amazon.com/gp/product/0780618068

Amazon: Michael VHS
http://www.amazon.com/gp/product/6304452683

My Google search strategy:

Google Web Search: pie travolta michael
://www.google.com/search?hl=en&q=pie+travolta+michael

I hope this is the correct movie! If it is not, or if anything is
unclear or incomplete, please request clarification; I'll be glad to
offer further assistance before you rate my answer.

Best regards,
pinkfreud

Exactly what I was looking for.