Bring a large pot of salted water to a boil and cook pasta according to package instructions until al dente.
Drain pasta and set aside.
Heat olive oil or butter in a skillet over medium heat.
Add corn kernels, smoked paprika, chili powder, cumin if using, salt, and pepper; cook 4-5 minutes until corn is lightly golden and fragrant.
Remove skillet from heat.
In a large bowl, whisk together mayonnaise, sour cream or Greek yogurt, shredded cheese, lime zest, lime juice, and minced garlic until smooth.
Add warm pasta and seasoned corn to the creamy sauce and toss until evenly coated.
Taste and adjust seasoning with additional salt, pepper, or lime juice as needed.
Transfer to serving dish and garnish with crumbled cheese, fresh herbs, and extra spices if desired.
Serve warm or slightly cooled.