I got the Super Slim after Thanksgiving and I find the spin-up/spin-down noise during gameplay to be extremely annoying. If it's just playing a cutscene and constantly spinning it's pretty quiet, but in gamplay it starts and stops all the time with the few games I've played (the first Ratchet, and Uncharted so far). I don't think Infamous 2 was as bad, so maybe new games are better, but so far it's been very noticeable to me.
Maybe I need to try putting the console behind my TV cabinet or something.
Can you install games to the Harddrive like on the 360? It has like 250GB that I'm not using, and I would love to install the games if just to silence some of the disk spinning.