These actually have two different casts. The first one with the pond and pagoda has a green cast, that can be fixed by just pulling down the curve in the green channel. The second has a pretty harsh cyan/blue cast that that is easily fixed by desaturating/darkening those colors with the HSL sliders.
Fixing these things isn't really the hard part. It is being able to look at the file and try to determine what part of what channel is causing it in the first place.
I tend to use a curves adjustment layer in photoshop to see where spikes in the histograms of each channel might be contributing to the cast. From there I can just grab those points to quickly determine if that will have the affect I'm after and fine tune from there. If that doesn't work I go on to create a Hue/Saturation adjustment layer, and choose the hue that looks like it will be the problem (like cyan or blue in the second picture—see screenshot) desaturate/darken/change the hue sliders until you determine just what the problem is and then fine tune.
I never had need to try to photograph a color negative with a dslr and then try to convert/correct it in Lightroom; that is not what those tools are designed to do. Sure, you can make it work, be prepared to need to do some extra adjusting and color correction. It is like trying to use a screwdriver to drive a nail. It will work, but it might be a little difficult, and potentially painful.