Hotels are spread out but most are nice in Hoover. There are several near the Galleria and Patton Creek shopping center. If you can't stay in Hoover, go toward Oak Mountain Amphitheater in Pelham or Highway 280/Summit. Only 15 minute drive and tons of food options in both places.
There are also several restaurants near the Met, but even more options up and down Hwy 150, near the Galleria, and Patton Creek.
For Food, I would suggest:
Biscuit Belly for Breakfast (YUM)
Jim and Nicks on Hwy 31 for BBQ
Uncle G's, Johnny Brusco's (both New York style) or Tortugas (chicago style deep dish) for Pizza
Hero donuts or Whiskey Foxtrot's (my fave) for burgers
There's 2 Korean BBQ places now that are both good. Hot Pot (near Walmart) and Stone Age (Galleria)
Rock and Roll Sushi or Styx for sushi and hibachi
Frontera for Mexican food (near Target) or Taco Mama (near the Met) for street style tacos
Feel free to @ me if you have more Hoover specific questions
Oh and stay out of Bessemer and McCalla. Nothing good to see there. Hotels are cheap for a reason.