Like you, I don't find stories about meaningful, yet transient relationships in any way entertaining......but there is an audience for it.....and from all accounts "Lost in Translation" did a magnificent job of achieving it, as well as achieving an overall atmosphere of loneliness etc.
It perhaps should be considered a very good movie that doesn't appeal to most people.