Thanks for all the good info.
Yes, there is a streetlight at the end of the driveway with a 60W bulb in it, so I guess a night vision camera will be able to see better than if it were pitch dark.
As far a budget goes, I need to keep things under $500 for now. Seems a real cheap solution is...