The Biblical story hardly paints David and Solomon in a positive light. Solomon is portrayed as very oppressive, and David gets a whole bunch of crimes, in part

The Biblical story hardly paints David and Solomon in a positive light. Solomon is portrayed as very oppressive, and David gets a whole bunch of crimes, in particular being this close to treason. In whose interest is that? The Judaen Kingdom should have known basic information about its history, lying from whole cloth or portraying its founders in that light isn't very useful to them. Everyone else who comes to rule that area later is made to be illegitimate (by implication) and it's not in the interests of the religious classes either (usually not big on rebellion, except the Hasmonean which never claimed to be descended from David and had their own text). I think reading Kings as a ancient text with all the typical flaws for the time is the right way to go about it, and the only way we can piece together the evidence (for now, barring some new discovery). Many ancient texts give absurdly inflated counts for armies engaged in battle, but we usually don't follow that by "battle never happened".