is there a list of such bad wallets to beware of? or a list of 100% good wallets?
You can't make such a list because most wallets are not intentionally bad at doing the things that DannyHamilton mentioned, because all of those are
user issues and usually not faults in the wallet software.
Specifically, if a wallet lets you choose a low transaction fee, or in the case of a full node, has settings for managing which peers or nodes it connects to, there are bound to be users who misconfigure all these things and have all sorts of problems with their transactions.
Very, very low as long as you can access pretty much everything else on the internet[/li][/list]
what do you mean?
He means if you are able to avoid common causes of transactions staying unconfirmed (using low fees, spending unconfirmed inputs in a transaction, and find resolutions for a stuck unconfirmed transaction like rebroadcasting it, removing it from your wallet/node's history and broadcasting another with low fees, using a paid transaction accelerator like ViaBTC's, etc etc (and you can find all this info on the internet) then you will have no problem getting your transactions to confirm.
so I can conclude that if I pay a solid fee amount and wallet is not faulty, the odds of the transaction being confirmed are > 99.99%?
Yes. (barring a failure of the wallet software and full nodes to broadcast your transaction)
and the say there's a re-org, which is also rare (1/2000 blocks? less?), then still, it will almost certainly be confirmed eventually
which would make the total odds extremely low.
A re-org that invalidates a block your transaction is included in just puts it back into the mempool so this case should be treated no differently than a regular unconfirmed transaction.
Three weeks, because I INTENTIONALLY paid an insufficient transaction fee. I was not in a hurry, and just kept re-broadcasting the transaction until transaction fee requirements dropped.
which wallets can make you do that?
Electrum, Bitcoin Core, Mycelium for android, many exchanges and web wallets like blockchain.com, Bitamp, Cryptonator and many more which I haven't used.