Prove me wrong please, I'm looking for an article on a game that didn't try to circumvent the low RAM, but worked with decent streaming.
I don't have any articles, but off the top of my head, I know Metal Gear Solid, Soul Reaver, and Jak & Daxter all use streaming. Grand Theft Auto 3 and it's progeny also use a lot of streaming, though there are a few cases in the earlier games where you have to load between islands.
I'm sure there are plenty more games that use streaming, you just can't notice it most of the time. Ideally, you'd have all your games using a seamless world system like SotC, but even if most games do load between levels, a lot of them probably do some form of streaming, considering how freaking stingy Sony is with their dedicated RAM.