I did wonder if Bitcoin transactions have any limit so I decided to check and i saw that that Bitcoins transaction limit is when the fees are higher than the value of what you want to withdraw,
and It is regarded as dust, just like wanting to withdraw ₦1000 and the fees is ₦2000 it doesn't just make sense

This analogy explain limit but it's wrong to map it to dust limit. Limit isn't calculated in currency which in this bitcoin case we can use $ but it's wrong, it's calculated in sats.
Another thing you need to know is that this limit varies from script to script. Legacy is bigger with 546 sats, taproot is 330 sats and native segwit is 294. The same limit on legacy of 546 sats can be spent if you have that on segwit versions, so put script into consideration.
Ans Also I came across something that satisfied a question I had for a very long time, which is the inconsistency of Bitcoin fees daily,
it's as a result of Many people sending Bitcoin at the same time, so fees will rise at that time because block space will become scarce
that is why fees rise during major news events or an aggressive rally
Yes, Bitcoin transaction fee are not static but the variation has nothing to do with your total transaction size. Transaction fees can be as low as 1 sat/vbyte and your transaction size can be large if you have many inputs and outputs, and the type of scripts you are spending on your transaction.
Mempool surge shouldn't be your problem if you have the above in consideration, transactions can spike and after a while it will reduce but if your transaction size is big, there is no any other ways than to pay for all the sats in that transaction.