I snug it up to just the point where I feel resistance in the steering. Then I tighten the two nuts together, and since this process slightly backs off the lower one, it usually ends up perfect.
No wobble with no resistance to steering is your goal. You can get away with a bit more overtightening with cartridge bearings than with balls. Too tight and it'll feel weird steering.