Pat the shrimp dry with paper towels and place them in a bowl. Season with the chili powder, garlic powder, smoked paprika, 1/2 teaspoon of the kosher salt, and the black pepper, tossing until the shrimp are evenly coated.
Set up a breading station with three shallow bowls. Place the flour in the first bowl. In the second bowl, whisk together the eggs and water. Place the panko breadcrumbs in the third bowl.
Bread the shrimp one at a time by coating each piece in flour, dipping it into the egg mixture, and pressing it into the panko until fully covered. Arrange the breaded shrimp on a plate in a single layer.
Make the sauce by stirring together the mayonnaise, sour cream, lime juice, lime zest, and remaining 1/2 teaspoon kosher salt in a small bowl until smooth. Set it aside.
Heat 2 tablespoons of the vegetable oil in a large skillet over medium heat. When the oil is hot, add half of the shrimp in a single layer. Cook for 2 to 3 minutes per side until golden brown, crisp, and cooked through. Transfer to a paper towel-lined plate.
Add the remaining 2 tablespoons vegetable oil to the skillet and cook the rest of the shrimp the same way, adjusting the heat as needed so the coating browns without burning.
Warm the tortillas in a dry skillet over medium heat for about 20 to 30 seconds per side, or until soft and flexible. Keep them wrapped in a clean towel to stay warm.
Assemble the tacos by filling each tortilla with shredded cabbage, several crispy shrimp, sliced avocado, chopped cilantro, and a spoonful of the lime sauce. Serve immediately with lime wedges on the side.