If you follow the excellent daily TSLA trading thread by
@Papafox you will see that he includes a chart of Max Pain evolution over time that is compiled by
@JimS. Looking at that you can see that the MaxPain value moves through the week and often comes close to converging with the share price . However often it's not the MaxPain value itself but instead the cross-over point between Put and Call walls that the MM are actually targeting. I'm not sure if anyone has done any more detailed statistical analysis but expect that
@JimS would have the relevant raw data on hand.
A lot of us trading options also pay very close attention to the Max Pain number, the Option OI chart and how it evolves over time. What I can say from my observations is that by about Thursday it is typically clear what target price the MM's will be aiming at based on the Options OI chart. When IV and trading volume is low I have noted that the MM's usually achieve their target, even if they need to manipulate the closing price to do so. However at times when IV is higher (say >50%) and/or volumes larger (much of the time recently) or there is some other news, then it is much harder for MM's to achieve a closing SP close to their target.
Edit: To look at historical Max Pain over time you can also head to:
Swaggy Stocks They include a graph of historical max pain vs share price over time. Although you have to login to see history over 1 month (up to 1 year).