Currently I have waited 3 hour
The worst longest time I have waited for 1 confirmation was when I sent from my wallet to a exchange and it took more then 2 weeks to confirm.
I was so nervous and used different btc accelerators and contacted the exchange support. I learned my lesson after this incident.
Im a kind of person who doesnt really want to wait thats why i do check out mempool.space and when i do saw what are the current fees on specific prioritization then im basing
on the fee that im using but those are subject to change which we know that network could clogged even more which would result into further expensive fees.
As for the question on whats the longest time that ive been waiting for some transaction then it do took 1-2 days. Getting broadcasted into the network and waiting
for 1 confirmation is really a stressful one.