Hi,
I think as far as film is concerned, red footage will always be soft because of the very structure of film stock. Red is the last layer, so when it's exposed the light has already been diffused twice (by the blue and green layers). Kodak and others improve this by tweaking the thickness of each layer and its content. (Check out the MTF curves)
I don't know how it goes for video.