See subject line. Obviously there is an absolute upper limit determined by the mechanical strength of the parts involved: wrist pin saddle, wrist pin, con rod, crankshaft, rod bolts. Spin too fast, and one or more of these parts will break.
A brief internet search suggests that before this strength limit is reached, there is an RPM beyond which the engine wear happens at a rapid pace. this page is pretty old, but it shows that for production passenger cars in which the engine is expected to last for well over 100K miles before being considered “worn out,” mean piston speed seems to be an important factor.
I applied their MPS formula to my 2003 Maxima and came up with 3479 ft/s, which fits within the guidelines they prescribe. OTOH, I tried the formula for my G37 which has a longer stroke AND a higher redline; I came up with 4297 ft/s, which is way out in the “very short life” region.
So maybe mean piston speed isn’t the primary determinant for longevity? What else is there? Can anyone point to technical publications (e.g. SAE papers) that might shed some light on this?