Retail rental of PS3 hardware is virtually nonexistent. Sony ended production 2017; major chains (GameFly, Redbox) stopped console rentals years ago.
Physical PS3 is cheapest for local play; PS+ Premium for streaming; RPCS3 for best visuals.