Cook pasta in generously salted boiling water according to package instructions. Drain and spread out on a sheet pan to cool. Do not rinse! You can add 1 Tbsp of olive oil to the pasta to keep it from sticking together as it cools.
Add eggs to a small saucepan and cover with cold water. Bring to a boil, then remove from heat and cover. Set timer for 12 minutes. When time is up, drain away hot water and replace with ice cold water. Let cool completely.
Chop red onion, red pepper, pickles, celery, cheddar cheese and hard boiled eggs. You want them to be fairly small pieces, similar to the size of the noodles. Finely chop dill and basil.
Whisk together mayo, sour cream, red vinegar, pickle juice, mustard, sugar, and salt and pepper.
Combine the cooled pasta with all of the mix-ins and half of the dressing.
Cover macaroni salad and chill for several hours or until ready to serve. I like to serve this macaroni salad within 48 hours of mixing, but it will keep in the fridge for up to 1 week.
As the macaroni chills, it will absorb a lot of the dressing. Before serving, stir in more dressing as desired (you may not use all of the dressing, depending on how creamy you want the macaroni salad).