That's not to say a mystery story is inherently a bad thing per se but having played the game for dozens of hours, after a while I simply stopped caring about who or what The Absolute was.
I think Absolute is mentioned too often and with too big of a focus, while actually not telling anything. For now, it is nothing more than something pulling the strings. Normally a game would engage us in smaller local conflict and present a compelling foil, only to than reveal there is more to it. BG3 screams from the rooftop that Absolute is behind everything, without creating any tangible connection with the Absolute. I don’t care about Absolute (naming characters is important and “Absolute” sounds… weak?) and even worse, I don’t care about characters we encounter in act1 as they are presented as little more than Absolute’s pawns.