You just need to set the object's origin and endpoint correctly for 'Point At' to work properly. This can be done with the joint editor.

That said, 'Point At' isn't always very successful when the object is pointing at a camera - a figure's eyes are a particular case in point. You may be able to get "good enough" results for something less anthropomorphic though.