My goal is to keep the desired object at the same position on the screen but at a zoom level I set

Based on the following:

One way to do this might be to place the motion tracker on a duplicate clip underneath the original. Then add the Size Position & Rotate filter to the original (top track) with your preferred zoom, and only then apply the motion tracker back to the original clip.

Also, I don’t think you should have to use two separate tracks, so check the order of your filters - the SPR should probably be below the motion tracking filter.

Untested.