I went to Powell botanic gardens in KC. Awesome sites. Very nice orchard and plants.

Not sure we have anything like that around here. I know Madison, WI has Olbrich Gardens which has a huge variety of plants, but not so much orchard type stuff. Maybe the UW arboretum has more fruit trees? not sure. I have been to the Fruit and Spice Park in Homestead, FL which has a HUGE variety of tropical fruits...amazing seeing that stuff growing in the US.

Redlands Fruit and Spice Park, SW of Miami, has occasionally seen my unabashed stained "been in the jelly jar" face for many a decade now, though not recently, alas.

North Carolina has an "old southern apple" park somewhere too, but I have not made it there yet.

I can answer for Madison, WI. The Olbrich Gardens really focuses on ornamental plants, except for a lovely herb garden (with two paw paw trees). They have a Children's Garden outside the main area, with fruit trees trained over the main aisle and row of veggies and flowers on either side. It's not huge, perhaps 20'x30'.

The UW Arboretum has zero purposely edible plants, as far as I can tell. They have a few nice juneberry trees, but they're left to grow really tall (25') so of course the berries are only accessible to birds.

Allen Centennial Gardens is in the middle of the UW campus, and it is well worth visiting. The director enjoys integrating edible and ornamental plants, and has had some amazing combinations the past few years. The fruit section has been neglected (I'm volunteering there to prune the poor plants), but it includes blueberries, gooseberries, raspberries, cornelian cherries, tart cherries, and a beautiful old Belgian fence of apple and pear trees. They have a lovely vegetable garden, and demonstrated lasagna gardening there this year.

I visited the Chicago Botanic Gardens this summer as well, and they have a large area of fruit and vegetables. Rows and rows of espaliered apples, pears, and cherries. Not very interesting varieties (a ton of Red Delicious), but I suppose they were donated. But very nice vegetable gardens and I was glad I made the effort to visit!