Can't say that he had a significant impact on my life but the very fact that I've heard of him and yet know almost nothing about American Football probably says a lot.
In cricket, we recently lost former player and commentator Richie Benaud who from what you've described about Madden above would be on a par for that sport and was often considered "the voice of cricket". Difficult if not impossible to replace guys like this.
I grew up worshipping cricket before my teenage years. My later teen years were all American football Madden and Richie is a great comparison. It's like two worlds colliding so perfectly
for sure. A lot of people will try, but it will probably be decades, if ever, that the voice that defined a sport can be replaced by anyone.