Coherence and superfluidity of Bose gases in reduced dimensions: from harmonic traps to uniform fluids