Baker Mayfield and other NFL quarterbacks once led their franchises with promise and hype—until it all fell apart just as quickly.