Given the intermediate status of the area, it's satisfyingly quiet, urban and a bit run down, leading to some awesome opportunities for photos. I think I'm going to be spending my next few weekends poking around to see what I can see here.
There's an active flickr group with many photos of the area. In particular look out for photos by natu®e, who takes some awesome pictures of the area. Hes also a bit of a ninja with his iPhone pics too - very compelling stuff.
Side of an parking garage in Mission Bay