At the risk of beating a dead horse, I have a bit more info on the Quicken/Mac OS X Lion debacle… According to MacRumors, OS X Lion will allow you to run multiple copies of OS X in virtual machines on a single computer. This means that you should be able to update to Lion (10.7) but continue running Snow Leopard (10.6) or earlier using VMware Fusion or Parallels.
Translation: If you have (or are willing to buy/install) Fusion or Parallels, you can update to the newest version of OS X while still running an older version that supports Rosetta, and thus Quicken 2007.
This is a somewhat clunky workaround, but if you’re willing to run Windows in a virtual machine in order to keep using Quicken, then you’re probably willing to run a second version of Mac OS X in the same fashion.
In other news, I received an e-mail from Intuit last night finally acknowledging the lack of compatibility. Their recommended solutions were to “upgrade” (i.e., downgrade) to Quicken Essentials for Mac, switch to Mint.com, or switch to Quicken for Windows.
Of course, there are other (non-Quicken) options out there. I will try to put together a list of these options sometime in the near future. If you have any suggestions, please leave them in the comments.