Non-Markovian Dynamics of Macroscopic Quantum Systems in Interaction with Non-Equilibrium Environments