Collective modes in deformed and superfluid systems within the ab-initio QFAM