I'm also umming an ahhing over whether I should upgrade, as I too am using 3.52-4. So from what I've read, here's what I'm thinking from 3.52-4 to 3.90-2:
Positives:
-More options/compatibility for pops (PSX emulation)
-Can play newer UMD's
-Can update to the newest M33 firmware by using the Network Update in XMB
-More options in Recovery
-Go!Messenger (you'd have Skype too if you had a Slim)
-Sony's internet radio
-Use themes, without having to mess with flash
-More visualizations in XMB's music player.
-Dark_Alex's released 8GB patches which now apparently make them compatible. They're a bit of a pain in the arse with 3.52-4; all 1.5 homebrew has to be loaded on first to work properly, meaning if you're ever wanting to install a new 1.5 app, you'll have to back up and format, and then re-transfer the entire contents. I've also had issues with plugins.
Negatives:
-You're now having to install the 1.5 kernal separately. I haven't actually heard any complaints of it not working properly, mind.
-Sony ****ed up one of their memory stick drivers, and whilst D_A's released several patches to fix this, I remember people still reporting slow downs.
-Less compatibility with IRshell, if you use it.
I've bolded what I think are the majors.
Bookmarks