A self-consistent cloud model for brown dwarfs and young giant exoplanets: comparison with photometric and spectroscopic observations