Yep, I am not an architect, and this certainly won't be done with my money
... but the fixes needed to at least make Memorial Stadium "good enough" really don't seem that hard. The space and "bones" are there, and we really do not need to tear too much down or replace too much to have a VERY significant improvement.
I am not sure how many seats are in each row, but according to
this seat map, there are nine sections (101-109) that each have nine rows (51-59) for a total of 81 rows underneath that overhang ... if you removed all of those and put them in front of and behind/above the current horseshoe seats, you do not have to increase capacity one single seat (and might even reduce it...), and yet you can make the stadium look infinitely better and more architecturally sensible.