Cook the macaroni noodles according to the package directions. Drain them and rinse immediately with cold water. Drizzle with about a teaspoon of olive oil and gently stir so they do not stick together as they cool.
In a large bowl, combine the cooked macaroni, diced sweet gherkins, red bell pepper, celery, red onion, and finely diced eggs. Stir everything together and set aside.
In a separate medium bowl, make the dressing. Add the mayonnaise, sour cream, red wine vinegar, sweet pickle juice, sugar, Dijon mustard, salt, black pepper, garlic powder, and crushed red pepper if using. Whisk until smooth and well combined.
Pour the dressing over the macaroni mixture. Toss gently until everything is evenly coated.
Cover the bowl and refrigerate for at least one hour. Before serving, give it one more good stir and enjoy.