Welcome Texas Tom!
Always happy to see another Lightfoot fan making their presecnce known.
I would say,as a fan it's just great enough to be in the building but I know how you feel. I was told I had a 4th row ticket but found out after I arrived it was a 4th row "balcony" seat.
Asie from scalpers,I'd check every legit ticket seller in your area. There's bound to be some kind of closer seat available. Unless it's sold out.
Once again,welcome and good luck!