Terrifying scene in Michigan -- a helicopter took a tumble and in a catastrophic crash ... right next to a lakefront restaurant, and the whole thing was caught on camera ...