We can say,
"I had a delicious breakfast"
because of the adjective, as opposed to
"I had breakfast",
where we don't use an indefinite article. As in this former case we have ONE specific breakfast. Why can't we treat the word "weather" the same way?
"It was such a great weather". Isn't it also ONE instance out of many?