Heat the olive oil in a large, deep skillet or Dutch oven over medium-high heat.
Sauté the chopped onion and minced garlic for 1 minute until fragrant.
Incorporate the celery and carrot, cooking for an additional 3 minutes until softened.
Increase the heat to high and add the ground beef. Cook, breaking it apart with a spoon, until it is no longer pink—about 3 minutes.
Stir in the crushed tomatoes, tomato paste, chicken broth, hot sauce, chili powder, oregano, garlic powder, salt, black pepper, frozen corn, and uncooked macaroni. Mix thoroughly.
Reduce the heat to medium or medium-low to maintain a gentle simmer. Cover and cook for approximately 8 minutes, until the pasta is nearly tender and the mixture remains saucy.
Add the shredded cheddar cheese and stir until incorporated. Sprinkle the mozzarella over the top.
Cover the pot again and cook for an additional 2 minutes, allowing the cheese to melt and the pasta to finish cooking.
Remove from heat. The pasta should be cooked al dente, rich in sauce but not overly wet.
Serve promptly, garnished with sliced green onion if desired.