Nashville Dawg here... I'd recommend staying either downtown or in the "Midtown/Vandy" area. Plenty of options from all the Marriott / Hilton / Hyatt brands and the Midtown/Vandy locations are very close to downtown for the game / downtown action. Midtown has some pretty good bars and restaurants too.
If you want to stay out from town, I'd say Brentwood is the closest and best option. There's a bunch of hotels near Old Hickory Road and 65, also in the Marriott / Hilton / Hyatt families. Before I moved back to Nashville, I stayed at a couple of Courtyard / Residence Inn locations near Old Hickory / Maryland Farms. As mentioned by others, the UBER downtown from Brentwood is pretty quick and only $15-25 depending on timing.
Team is staying at Opryland... I'd say go check out the Christmas lights and stuff, but wouldn't recommend staying there. It's far from everything you'll want to do in town except the airport in and out.
For those inclined, AirBnB is huge here in Nashville... can generally find some solid spots not too far from downtown. Look for places in Belmont-Hillsboro, Sylvan Park or even East Nashville. All pretty good areas with some good neighborhood restaurants and bars.
Hope this helps!