I haven't been there in a few years, but the 18th hole at Van Courtlandt Park, an NYC muni had a sign on the tee saying you were not allowed to drive the green.. Its 272-313 yards on their website, but blind tee shot down hill, and has an obstructed view of the green behind some trees... Its not about the adjacent property, but safety from being getting hit by the group on the tee... The sign isn't quite as intimidating as that one though.
There is very good golf course in New York that has had someone sitting in a cart marking where every tee shot goes on a hole along the property line, for most of the last few years... There is already a screen fence, and tree fence... no sign, but this is well documented for legal reasons.