How was it? Fantastic! I think it could very well be the best SSS in the US/Canada. It is close-ish to town, maybe 3-4 miles from downtown, so not a close as Nissan Stadium. It's built in the middle of a neighborhood which really lends to the atmosphere but it does make parking a little more difficult. However, if you are willing to look around, arrive early and walk a little bit you can park in the surrounding neighborhoods for free. We arrived 2 hours before kickoff and parked about three blocks away from the stadium and got out relatively quickly.
The concession options are top-notch and it's the biggest SSS in MLS (Seating 30,000) so it can get pretty loud. Being in Music City they really bring that entertainment factor to the stadium too with live music all around the stadium before and during the match. It's easy to get in and out with super wide concourses. Probably the only complaints I have are the sound system is a little weak, the video boards are a little undersized and not the easiest to see from all parts of the stadium, and finally the overhang allows for some pretty weird shadows on the pitch in late afternoon/early evening. But the sight lines are really great from just about anywhere, no dead spots anywhere.
If you are ever thinking about going to a game there I would say don't hesitate.