Can a cortizone (hydrocortisone) shot have the opposite effect. I am feeling more pain in my knee than I did before the shot?

Possible. Not an "opposite" effect, but sometimes can produce local irritation. Your doctor should be made aware so you can follow this to resolution and ensure that you don't have infection.