Prison is often a “very expensive way” of making the lives of vulnerable women worse, the inspector of prisons has said.