It's a standard 5/16" square rod. Your idea is ideal, however, I don't happen to have any of those in my junk box.
The "threaded weight" is not a weight. but more of a threaded "stop" to be used with a screw-on handle found on many spits. My rod is not threaded, so I can't use that part. I do have a set of dies, but my rod end sits in a cradle, so attaching the counter weight to the end is not an option. It has to be inside the grill, close to the bird. I do need some kind of clamping hardware, but what and where. I have some ideas I will try to post later.
Turkeys are very hard to balance, and also tend to move around during cooking. My last two attempts have resulted in stripped gears and/or failed motors leading to brurnt turkey! Not good.
I did that and found no one using this style counterweight without the screw-on handle mount. I need to improvise.