Not much. Initial loading, mostly. Texture pop-in/out is a matter of managing your VRAM. The game will typically have the textures in its own memory, to put into VRAM. Then, when it spills out of its memory--with a 32-bit game that's sure to happen--the texture files will still be in the OS' file cache. Only if not there, will it have to go back out to disk.
But, if you can afford it, get an SSD. Even if it doesn't make your games much faster, once loaded, it'll make everything else much faster.
Another video from the PS3, but I think it applies to the PC too just not as drastically.
http://www.youtube.com/watch?v=Gosf3YUgdqM
No.
PS3: 0.25GB RAM, 0.25GB VRAM.
Typical gaming PC: 8-16GB RAM, 1-3GB VRAM.
The PS3 offers game devs no other choices, if they want better texture quality than you were used to in 2003-2004 on a PC.
If the game engine goes and does all that, you'll still have that pop-out/pop-in, but you can safely blame the developers, not your PC. Rage, FI, would typically work much better after doing some config modding.
Ok, let me give you an example my "HEAVILY" modded Skyrim installation has a total size of 36GB, the majority of this is due to High res textures, the game uses 3.2 GB RAM max, how can you feed the RAM only once if the game is open world?
A 4GB Geforce card, and 48-64GB system RAM

(but if you have a lot of VRAM, you can deal with textures being loaded in). Skyrim tries to preload textures before you need them, and if you have enough VRAM, you will not notice, because it will be ale to discard old textures you don't need, and load in textures you'll need for nearby cells, before they need to be used to draw a frame.