Bring a large pot of salted water to a boil. Add the elbow macaroni and cook according to package instructions until al dente, about 8-10 minutes.
Once cooked, drain the macaroni in a colander and rinse it under cold water until cooled to stop the cooking process.
In a large mixing bowl, combine the mayonnaise, sour cream, apple cider vinegar, sugar, Dijon mustard, and paprika (if using). Whisk until the dressing is smooth and well combined.
Add the cooled macaroni to the bowl along with the chopped onion, celery, green bell pepper, and sweet pickle relish. Stir gently until well coated in the dressing.
Season the salad with salt and pepper to taste. Adjust the sweetness by adding more sugar if desired.
Cover the salad and refrigerate for at least 1 hour before serving to allow the flavors to meld.
For added crunch, consider topping the salad with crushed potato chips before serving.