I've played with the release candidate. Much better than Vista was. I'm no fan of MS Office or the ribbon interface.
I've been using OpenOffice the last few years. Give it a try. It's free and compatible with MS file formats. The only caveat is it's not as compatible with some of the advanced and macro features of Excel. If you rely on the less common features of Excel, OO will not be sufficient.
OpenOffice.org - The Free and Open Productivity Suite Bonuses include a smaller footprint and faster response. And free of course.
Still, I'm not finding a reason to upgrade to 7 until I build my next PC probably in early 2011. I'll go with the 64 bit version.
Technology News, Computer and Notebook Reviews, Computer News, Computer Mods, PC News | Maximum PC is a good magazine for nerds and they'll have some good info on their site for Windows 7. Some of them are about the RC but will still largely apply.
20 Windows 7 Tweaks & Tips ? Every Secret Uncovered to Date | Maximum PCWindows 7 Review: XP vs Vista vs 7 in 80+ Benchmarks | Maximum PC
They have a guide in print right now I saw yesterday at B&N but I wait a couple of months for these things to show up in their free PDF files.
PDF Archives Technology, Computer PDF Archives, PC PDF Archives | Maximum PC - All of the Best Software and Hardware Reviews | Maximum PC Check back monthly to see recent back issues that will have more info for you.
Other freeware I rely on for windows is Comodo for my firewall but it's not friendly to non-techies. For average users, Zonealarm is my recommendation.
ZoneAlarm by Check Point - Award winning PC Protection, Antivirus, Firewall, Anti-Spyware, Identity Protection, and much more.
Avira for anti-virus duties
Free antivirus - Avira AntiVir
Spybot, Super Anti spyware, Malwarebytes do the spyware jobs
Handbrake for ripping dvds, Exact Audio Copy for ripping CDs, VLC for video playback. Have a number of different audio tools for different purposes. Foobar, MediaMonkey(good automated tagging), Quintessential player.
In fact, Maximumpc wrote an article on freeware apps that covers lots of what I just wrote.
The 32 Totally Essential (and Free) Apps for Every New PC | Maximum PC