Ground level - Be prepared for having a lot of people crammed into a small space. It's loud.
2nd level is better. But, yes, you'd have to get up & down the stairs if you have to change fields.
By the end of the day, there's a damp, dusty haze in the atmosphere.
And you sometimes have to get creative to find parking.
But, I love the SpanoDome. Where else can you play on real dirt in January, with 2/3 of an outfield?