As a note, yes, I have more than a few 500 foot runs now and they are all working fine. I have had 500 foot runs going for over a year with no issues at all of any kind actually which surprised even me. I am running Hikvision bullets at the end of these long runs and I have at least 20-30 500 footers and one is close to 550. I once tried on my workbench two separate cables coupled together for a total length of 1000 feet and it would not work, the camera powered up and I could see it in SADP at times and even get logged into the camera but could never see video. I have never tried on a solid spool but I would say 1000 is too long. I am totally comfortable with 500 feet now and do not even worry about that.
I often use fiber too, for example I have locations that I have a switch connected over 600 feet of fiber, then cameras 400 feet and farther form that fiber connected switch so my total distance from my NVR is 1000 feet or more.
I also use Ubiquiti wireless, so I have a 450 foot wireless shot that then connects to a switch and then I have 8 3mp cameras on that and one of those cameras is where my 550 foot run is. I have wireless with as many as 14 cameras connected and then wirelessly coming back to the NVR and the Ubiquiti equipment is cheap and rock solid. Cannot believe how well it works for such inexpensive equipment.
I do the long runs when I have to, as in I really have no choice because of lack of power and or no place to put a switch. All of my cameras are outdoor and in most cases I am retrofitting an existing location so my options are more limited. I greatly prefer proper planning during the construction phase so I don't have to worry as much but in the end the solutions I am using at the distances I need are working fine so I'm not too concerned about the longer runs now.