This place is no Lambeau Field but it's far from a dump. My time spent here in 125 was for a Titans/Colts game and it was a fun time sitting amongst all of the season ticket holders. Didn't like all of the stair climbing involved with getting to and from our seats though. The rows are also really long so when we needed to exit, the entire row had to stand up. If you get the aisle seat, you won't have this problem but instead will be the one standing to let everyone out. Another thing I didn't like about LP Field is that it's design doesn't allow the crowd noise to become a factor. If I was a player for the visiting team, I wouldn't be intimated by playing at LP Field, not one bit. There were numerous videos in between plays that would ask the crowd to get loud, one even featuring Rick Flair. Fans should know when to get loud and when to shut up at certain points during games.
Looking at the stadium, there doesn't seem to be a bad place to sit. Upper level didn't seem to be too high up and there are no upper level endzone seats, period. Very similar design to Everbank Field in Jacksonville.
We stayed at the Hilton downtown which may easily be the nicest hotel in Nashville. It's a short walk to the stadium, you just have to cross the big bridge and the stadium is on the other side of the River. I will warn you ahead of time about all of the "Interesting" characters you will encounter on the bridge.