A $5 million Brisbane road which was recently upgraded to prevent flooding has been destroyed by the recent heavy