I'll stick my neck out here and say that con rod failure is NOT a generic design fault with the Max. There will inevitably be failures but this can be down to various factors including poor or non existent maintenance or abuse e.g over revving by the user. As this is a Forum for V Maxii all manner of faults are mentioned so it is, perhaps inevitable, that even rare occurrences will feature. How they compared with other bikes I know not as I'm not aware of any collated statistics on the issue.
The maximum wear limit on the big end is is 0.0035". How much over that would it have to be before it was evident by trying to move the rod?
Once again, I'll stick my neck out here and whilst there is the occasional report of noisy small ends (as opposed to failure i.e. breaking) it is NOT common.
The 'orange O ring' saga has been going on since I first joined this and other forums and has (IMO) probably generated more paranoia among owners than any other issue. What percentages of bikes are affected I know not but as Yamaha didn't feel the need to issue a recall then it is likely that any problems this could cause (engines failure, press and owner publicity) was not felt to be sufficient to require action (unlike the Honda camshafts). It wasn't until the early 2000's that the pick-up was modified (over 25 years since the bike was unveiled) so they hardly felt it was an issue. If it had been then they would have identified this from warranty costs, parts usage and customer feedback. There have been and in all likelihood still are bikes that have been running for many years with a displaced O ring without any issue.
Page 5-3 of the owners manual states 'Never accelerate hard with a cold engine'. IMO displacement occurs when owners ignore this and before the oil is up to temperature. When cold oil pressure is around 60 psi on fast tick over but will drop to around 3 or 4p.s.i. when hot.
Depending on your level of paranoia there are several things you can do. Already mentioned is the Kawasaki oval O ring (part #92055-1147), fit a so called engine saver bracket that limits how far the pick-up tube can move or fit the later pick up tube.
If I was considering a Max one of the last things I would be concerned about is internal issues with the engine provided it has been treated with respect and serviced regularly. And if that has been done then higher mileage bikes are not a problem.
That said the adage 'buyer beware' still applies.
I wouldn't buy a bike sight unseen unless it had been checked over by someone I trusted. Even then I would prefer to meet the owner to assess not only if what was claimed checks out but also if the body language fit the comments.
I hope you get a Max and we are always happy to offer our two penneth.