You really need to listen to the full 6 min original album version rather than the single edit / official video. It builds up the tension so his voice seems to explode mid song and also has an vital ending thats cut off by the single.
As someone who's been used to Bowie since the mid-70s, 'Heroes' is far from my favourite track on the album. It's still very good, but I prefer the other tracks on this album. Try 'Beauty And The Beast' (Live Musikladen 1978). The rhythm is dense and almost danceable, but the rest is more schyzophrenic, and it's this duality that I like about Bowie! (Which, unfortunately, you don't find in his albums from the mid-80s to the end of the 80s).
You aren't really a Bowie fan right? You're not able to conceptualize his different music personas or you would appreciate how far ahead of his time they were. The album Let's Dance had good stuff but it was his most commercial & his own least favourite because of that very fact. Still each to their own, if it's what resonates with you at least it you appreciated some of his creativity.
Honestly, I think at the time I was young and lacked the artistic maturity to appreciate music beyond the catchiness and the beat. Bowie to me at that time was music for my older siblings. By the time I was older, I was pretty set in my musical tastes with the flavor of the day, so to speak. I was aware of Bowie, but didn’t really get him until he worked with Giorgio Moroder on the soundtrack of “Cat People” oddly enough. That’s the beauty of reaction channels. I can connect with deeper fans to gain a deeper understanding of artistic genius. Thank you so much for being a part of my education Helen.