Streets on record is just as good as live, but it is a different animal.
When live, they put the guitar riff loud as f*** and, well, loud is more exciting. Then we have that intense energy from the rhythmic section resonating throughout the crowd with Bono's emotional delivery, so it's a massive social experience. And, of course, there are mini improvements, like Adam's new bass line in the chorus.
On studio, everything is different. The famous guitar riff is NOT the main dish of the intro, but a quiet sparkle added to the the slow melody of the synth we've been hearing since the beginning of the track. This restrainment makes the whole intro have a much deeper sense of "crescendo", instead of just loud, and the first 30 seconds are pure Eno's genius (it's so beautiful!). Then we arrive at the verses, and Edge's work on studio is pretty interesting, with that helicopter sound and lots of guitar layers. Really, the amount of things vibrating and resonating simultaneously is unbelievable (of course, sound is vibration, but I mean in a broader sense of the word).
There is more. The amazing crescendo of the song goes through not only the intro, but to the very ending of the song, because the outro is the biggest sounding part of the track. Oh, and I love the outro of the studio version much more than the bridge they do live. I will never understang why they don't do the outro live. Bono singing "bloooow by the wiiiiind!" gives me shivers down my spine everytime. It goes without saying that all this superlative apotheosis makes the smooth comeback of the guitar riff much more nostalgic and beautiful.
Yes, I love this song.