There is a "total let-down" for rail passengers in the north of England, a transport committee hears.