Bring a large pot of salted water to a boil and cook the macaroni according to package instructions until al dente. Drain and rinse with cold water to stop the cooking process. Set aside.
While the pasta cooks, place eggs in a medium pot, cover with water, and bring to a boil. Once boiling, turn off heat, cover, and let sit for 10 to 12 minutes. Transfer eggs to an ice bath, then peel.
Separate the egg yolks from the whites. Chop the egg whites and set aside.
In a small bowl, mash the egg yolks with mayonnaise, yellow mustard, Dijon mustard, vinegar, paprika, salt, and pepper until smooth and creamy.
In a large bowl, combine cooked macaroni, chopped egg whites, celery, and red onion.
Pour the yolk mixture over the salad and gently stir until everything is well coated.
Taste and adjust seasoning if needed.
Cover and refrigerate for at least 30 minutes before serving for best flavor.