Is it safest to double check my new bitcoin address never showed up in the Ledger (the blockchain) before?

I just noticed in my Coinbase Pro, I can click deposit, BTC, and get a brand new address every time. It probably is due to “address is very cheap”. It can be just a new pair of private key and public key, and from that, a shorter “address” can be created.

So since an address is a shorter version, the chance of collision is higher than the private key.

Let’s say if a person is to deposit US$300,000 or $3,000,000 into that address, would it be safest to double check that this new address never showed up in the blockchain (the ledger) before?

Otherwise, is it true that when there is a collision of address, both that person’s private key and mine can move this bitcoin amount to else where?