> - Completely perfect and devoid of all realities of life

Friendships are relationships that stand the test of time and hardship. You work through problems, illnesses including mental health struggles, deaths, employment and money problems, family and relationship problems, legal problems, all sorts.

> - No jealousy, no competition, no negative feelings

There are obviously always mixed emotions, but generally you won't harbour serious ill will towards your friends. This is something you can work on, though, as jealousy and envy are personality traits that can be controlled. Healthy competition is a positive, though.

> - Timeless and immortal

Friendships change and sometimes have to be ended, even when you like the other person. I think this is quite common and almost a trope of Hollywood movies.

> - No effort involved

Short of family and maybe employment, friendships require the most work in life. This one is particularly baffling from a Hollywood perspective, as going a friend in need is like the all-time Hollywood trope.

> - Completely balanced and healthy for everybody at all times

Obviously this isn't true, but this isn't portrayed either. Flawed characters are the only compelling characters in Hollywood.

> - Able to talk about every topic

Again, changing the uncomfortable topic trope is an ultra-trope.

Your "realistic friendship" section fits acquaintances rather than friends.

>I think these unrealistic expectations undermine real-world friendships because they always fall short.

I think some self-reflection is in order here, as this is projection.