I have a Bitcoin wallet with a (bc1pt*******) address and received tens of thousands of small (2000 Satoshi) payments.
How can I get the lowest gas transaction balance?

You need to wait for mempool to accept low fees. Around 1 to 2 sats/vMB. Then you can consolidate all address and send all to one single address. Right now it's unimaginable.