Things start getting much
better in Season Two. I don't think Season One is awful, but they were clearly still finding their footing and figuring out what worked and what didn't. I thought the second half of the season was much stronger than the first.
Castiel first appears in "Lazarus Rising," the Season Four premiere.