I've been thinking about how Cyberpunk really did the "Dream Figure" character better.

Silverhand's always there giving his thoughts/opinions on different things during certain Gig's and the main quest. That he'll also react to some of your choices (Some of which actually matter in getting the secret ending).
The Guardian never does this. The Emperor does but only in regards to the Hammer, his Hideout and Ansur.

It also made me think that maybe BG3 was never meant to have a happy end for Tav and crew?

Admittidely, bit of a reach, but based off the two known original ends I've read (A deal with Raphael and Mindflayer transform "Down by the river"), that maybe the others were equally bittersweet?
And since Cyberpunk's endings were all equally bittersweet and sad (and maybe not that well liked; I mean, I imagine most people want happy endings) that Larian decided to go with the current ending, where the tadpoles just suddenly vanish.