In Lightning, the sender can never be sure that a multi-hop payment will go through, as intermediary nodes don't announce the distribution of funds in their channels (only the total capacity). Is there any publicly available data on how many attempts it takes on average in practice to route payments of different sizes? Something like this (the numbers are my wild guess):
Amount - Average paths tried
100 sat - 1.8
1000 sat - 3.3
10000 sat - 5.9
1000000 sat - 13.2
There is a similar question Lightning network routing failure rate and a 2018 article linked from there, but it addresses the success probabilities based on capacities only (this can be calculated from a network snapshot). I'm interested on the data from real-world transactions.