Over the course of my lifetime, I've seen virtually every possible type of offensive scheme be successful. And I've seen the same schemes fail miserably.
It all comes down to execution and personnel. the right people with the right coaching running the right play.
In the 60's and early 70's, option offenses were the thing - the wishbone, the veer, the triple option. Then, the game opened up, and we started seeing run-and-shoot type offenses. Then things became a bit more balanced. And now, we almost see conferences each having their own identity. B1G tough and physical. Big 12 wide open, 60 passes a game. SEC run-based with some play-action passing. Of course, there are exceptions within each conference.
But, in a nutshell, I would say any scheme can work, if you commit to it 100%, and have the right coaches and the right players to run it. Then, all the coaches will get together at a clinic and brainstorm a way to slow down the new hot offense, and everything will evolve again.