I absolutely hated it. If you just wanted to switch between games you had to get up and physically get the other CD. Oh and you better not drop that CD or scratch it, or your game might be lost.
Besides that buying games sucked too. Nowadays I can buy and download a game in an hour tops, smaller games in minutes. Back then you had to go to a store or wait for shipping…
Don’t get me started on DRM, SecuROM doesn’t work nowadays, so all games you bought with it are broken.