I have a mid 2007 iMac too and I did a test install of ML on a seperate partition and it was much more fluid than Lion.
The stuttering I used experience with Launchpad and Mission Control etc were all but gone and Safari 6 was a big improvement.
I would advise a full, fresh install though. I've never had any joy with upgrade-installs.