Pretty much the same for any situation I can think of. A relationship, a play, a movie, a wait.

'It's over' means that something has come to an end. Example: Our friendship is over. 'It's over with', if I'm not mistaken, can be utilised to refer to when you have finished a task or something else or when you can't stand a person/something anymore. Examples: I'm over with my homework. I'm over with this boring film.