Collective effects and optomechanics in ultra-cold matter