Prepare the corn by removing kernels from fresh cobs or draining and rinsing canned corn; if using frozen, thaw and drain well.
In a spacious bowl, blend together sour cream, mayonnaise, and softened cream cheese until the mixture is smooth and creamy.
Add the shredded cheddar and pepper jack cheeses, stirring to combine evenly.
Incorporate garlic powder, onion powder, smoked paprika, chili powder, and season with salt and pepper to your preference.
Gently fold in the corn, green onions, red bell pepper, jalapeño, and cilantro if desired, ensuring all ingredients are mixed well.
To serve cold, cover the dip and chill it in the fridge for at least 30 minutes to let the flavors develop, then garnish as you like.
For a warm version, heat your oven to 375°F (190°C), transfer the dip to a baking dish, sprinkle extra shredded cheese on top, and bake for 20 to 25 minutes until it’s bubbling and golden; garnish before serving.