The story I'm looking for had Chuck as God returning to heaven and deciding he needed more Archangels. He asks the Winchester, as well as Ellen and Bobby, I think, to become the new Archangels. I remember one of their wings being described as a vivid red.