I have a Toyota Verso, and the backup camera is close to the tailgate handle, beside the license plate. No moving parts etc, and rain per se isn't a problem, however it tends to get dirty in foul weather. I have a habit of just wiping the lens with my thumb every now and then, works well enough.

And yes, it definitely makes parking in a tight spot easier.