A Picatinny mount will never stay tight on a Weaver rail... Just saying
hog wash BUT you might have a hard time getting a tru mil std pic mount to fit in the narrow weaver rail grooves/slots if it has the slots across it and your ring or mount has the "recoil" lug that fits the rail slots.
Mil Std Pic rail is something like .200" wide and evenly spaced vs the weaver .175" wide and often only has a few "Slots" not always evenly spaced = sizes going on memory
now if your mounting a rail weaver rail with no recoil slots or rings with out any recoil lugs you can/will have issues with scope ring movement. once things start to move they will come loose.
I would not be surprised today if most manufactures just slap what ever label they want pic or weaver and just machine to the larger side of specs.
with less expensive rings/mounts they will often come with round or the thinner "recoil" cross pin to fit both.
As for torque , growing up my dad said for those thumb screws, well thumb screw tight grab it with your thumb and index finger and tighten it. Then apply the same thought for the other scope/mount/ring gun screws.
A torque wrench will do better preventing over tightening than under tightening.
Also if you use Loctite and it does not seem to work 2 things going on. You have oil in and on the threads/holes and also lots of metals need their primer to get a very good hold. I prefer 222 Loctite on any small gun screw IF I use it at all. Even liquid Teflon will help hold screws tight.
Also the quality of the threads will play a big roll, if the hole or screw is "loosely" machined it may never stay tight.