'I am tired of you' is correct. 'I am sad of you' is not. You can say 'I am sad for you', which means that I feel pity or sympathy for you. Other examples: 'I am angry with you', 'I am bored with you', 'I am happy for you'. I guess that you need to know which prepositions collocate with which emotions.