If you set up your tripod and took a photo of a subject with a 600, 300, 150 and 75mm lens all from the same place, then cropped the 300, 150 and 75mm images to the same as the 600 then the main difference would be the resolution, as you have to crop away more and more of the image.
If, however, at each step you moved the tripod forward half the distance then the subject would stay the same size but because the camera is getting closer each time the perspective to the background would be changing and the FOV would appear totally different because of that.
The longer focal length means that you can fill the frame with the subject from further away without having to crop into it as much.
You'll hit a point where you sill start getting worse results - not necessarily because of the lens but because of the atmospheric conditions. Heat haze caused by he sun heating up the ground will give a mirage like image and start to blur objects further away - tyhis all depends on location and conditions.