John Prescott's regional assembly plan has been attacked by MPs as "disappointing, lacking ambition and failing to devolve enough power".