Ion acceleration in the transparent regime and the critical influence of the plasma density scale length