I have a family member who happened to have purchased ColdCard hardware wallet before the attack that happened last time, he showed me some hours ago and he hasn't deposited any amount of crypto coins in it.
It's why I find this thread to ask this question, is it still a good idea to keep using Cold card? Are you saying here that someone new takes over the company or it's just new maintainers you are talking about?
What do you have to say about this advice? Should I tell him to avoid using the hardware wallet and get Trezor or he should keep using this Coldcard hardware wallet? What would you do if it's someone close to you?
According to Coldcard and its team, the entropy vulnerabilities that resulted in the hacks have been fixed in the latest firmware releases. Coldcard is source-verifiable, but whether or not this can be checked is not for me to say. Regardless of what they claim, I would personally never use a Coldcard for anything. It's good that your friend never used it and stored his bitcoin on any addresses it generated. Especially without a complex seedphrase.
I would forget about the Coldcard forever. Trezor is ok but it's a downgrade compared to another airgapped hardware wallet. Devices that belong to the same class as Coldcard but work include Passport Foundation, Seedsigner, Shieldsigner (fork of Seedsigner), Krux and its fork Kern (I am not sure about the name), Jade and a few others.
Considering the latest problems with supply chain attacks, it's better to purchase directly from the manufacturer than a reseller, even an official one. Going down the DIY path and building one yourself is the best option right now. That and generating your own entropy with dice and coin tosses.