add tracking camera at cursor in Blender

add_cam_track_to_cube.py

import bpy

cursorLoc = bpy.context.scene.cursor_location

# create camera at cursor
cam = bpy.data.cameras.new("Camera")
cam_ob = bpy.data.objects.new("Camera", cam)
cam_ob.location = cursorLoc

# add to default collection
col = bpy.data.collections['Collection']
col.objects.link(cam_ob)

# track camera to default cube
trackCube = cam_ob.constraints.new("TRACK_TO")
trackCube.track_axis = "TRACK_NEGATIVE_Z"
trackCube.up_axis = "UP_Y"
trackCube.target = bpy.data.objects['Cube']