The Fabrication Yard
It's the classic spot for car photoshoots, with a scenic background that can be used for a variety of looks, from industrial to urban decay.
As a public park, it's free to visit, and you can just show up and take pictures anywhere, though be respectful of the businesses that operate around it.