Cook the pasta: Boil the macaroni in well-salted water until just past al dente.
You want it tender but not falling apart. Drain and rinse briefly under cool water to stop the cooking and remove excess starch.
Season the pasta base: Transfer the drained pasta to a large bowl. Sprinkle with the pickle juice (or vinegar) while it’s still slightly warm.
Toss to coat so the pasta absorbs a little tang right away.
Make the dressing: In a separate bowl, whisk together mayonnaise, sour cream, Dijon, sugar or honey, garlic powder, onion powder, a pinch of salt, and black pepper. Taste and adjust acidity or sweetness as needed.
Prep the mix-ins: Dice the ham and cheddar into small, even pieces. Finely chop celery, red onion, red bell pepper, and pickles.
If using peas, thaw them. If adding eggs, chop them now.
Combine everything: Add ham, cheese, celery, onion, bell pepper, pickles, and any optional add-ins to the pasta. Pour over the dressing and toss gently until every piece is coated.
Chill to set the flavor: Cover and refrigerate for at least 1 hour.
The salad will thicken as the pasta absorbs dressing, and the flavors will mellow and blend.
Final seasoning: Before serving, stir the salad and taste again. If it feels a bit dry, add a spoonful of mayo or a splash of milk to loosen it. Adjust salt, pepper, or acid to your liking.
Serve and garnish: Top with chopped parsley or chives for freshness.
Serve chilled or just cool.