What would happen if Hoover Dam were destroyed?

The only credible answer to your question is to the amount of water. Of course it varies, but is around 28 million acre feet. Since it generates about 2000 kilowatts of of electricity, its loss would be catastrophic.