Scaling up quantumness: from few-body paradoxes to many-body resources