How tight should the process connection be?

Follow the torque in the manual for the thread size, then check the zero after installation.

Over-tightening distorts the diaphragm or crushes the seal: the unit still reads, but the zero has moved and the error appears only at low pressure. If no value is available, tighten by hand plus a quarter turn on a G1/4 thread and verify the zero before commissioning.