He almost certainly will not approach Bagwell in career WAR. If that’s not how you would define “greatest,” that’s fine, but there will likely end up being about a 10-15 WAR gap between he and Bagwell.
Disagree that he’d get into the HOF if he retired after this season. Not arguing that he shouldn’t, mind you - just that he wouldn’t. The Hall favors big counting numbers, and the more contemporary voters who are less concerned about them place extra emphasis on high WAR/value peak numbers. There just aren’t that many short career guys in the Hall. Puckett is a good example, but I seriously doubt he’d get in had his career ended recently (I don’t think modern voters would vote him in).
The exciting part is that last season was maybe his best (along with 2017) and he’s actually been better this year, albeit in limited time. The last two years, his walk have increased, moving his OBP up; it looks like it may be the next phase of his continued evolution as a hitter. If he has a couple more healthy seasons in which he performs at the level of 2022-23, he will be just about there.
There is of course the asinine sign stealing bullshit, but I think as more time passes and more people objectively acknowledge that the entire thing was less a “scandal” than it was a sensationalized story about what amounts to a baseball tradition, as more evidence mounts that it made absolutely zero detectable difference in his performance, as evidence that he didn’t even really participate anyway is reinforced, I doubt it keeps him out of the Hall.