As far as the Lightning Network is concerned, I think it has all of the capabilities of surpassing VISA in terms of TPS. What's limiting the LN to go full speed ahead is the lack of mainstream adoption. Not to mention, the LN is limited to Bitcoin's own transaction capacity.
So which one is it, it has the capability or it is limited

That block limit will most likely stay like that for years, I don't see anyone ever challenging it, and not a single of the current dev proposing this so it will all have to come from the capacity of the channels and finding a way to keep the coins spinning around in the network, which brings us the problem with the limited service offered, and so on and on.
But in the end, why does it have to compete on Visa's terms?
I don't think that we will have to soon the number of customers using bitcoin to rival Visa even with the capacity, what Visa has and bitcoin will never have with a 3rd party service is the easy usage for their cards. You swipe your card, payment in seconds, card accepted everywhere, you lose your card you have somebody to call, you have the funds in your linked bank accounts insured, those are things bitcoin will never be able to do.
And a lot if not the decisive majority will appreciate those more than being their won bank like a lot of them don't like this responsibility that comes with it.
Before bitcoin can challenge Visa there are a lot of things that need to change, with one of the most important being how people think and act, and this will take a while, maybe even a decade is an optimistic scenario.