Destiny 2 developer Bungie has teased Cayde-6's return in a trailer for The Final Shape.

source https://www.windowscentral.com/gaming/destiny-2s-cayde-6-returns-in-new-teaser-trailer-for-the-final-shape-dlc