IMO, the maximum range for the cartridge, is the point where the velocity drops below 1800 fps. Even at that speed, bullet expansion will not be fantastic. ( this doesn't really apply to "pistol" calibre cartridges, or older, originally BP cartridges that use bullets designed to expand at that velocity.)
The maximum range for the shooter, should be the distance where he/she can consistently group all his shots onto a paper plate. For me, that's 300 yards, or a bit beyond, because I don't have space to practice beyond that range.