Just practiced an object along a path which works fine, but then tried a camera and getting very strange results. I definitely think I'm missing something.

Any suggestions ?

Works fine. Post your file.

I recreated the Cam & path, this time an odd displacement isn't happening but the Camera is still far away.

Everything seems to work perfectly fine, just make sure you reset your pretransformations and orient the camera accordingly to wha you are looking for.

Also, make sure you animate the camera long the path which is something Houdini does not set up for you of course.

Hope it helps