I sprayfoamed some of the knee walls around my FROG (finished room over garage), and it wasn't too bad. I pulled the fiberglass down, sprayed an inch of foam, and stapled the fiberglass back up. Unfortunately, I can't get to most of the knee walls to finish the job, so that room will always be closer to whatever the attic temperature is than the rest of the house.
If you aren't going to spray foam the entire attic, at least take a day and air-seal it. For the areas I didn't cover in spray foam I've gone back with a couple of cans of spray foam sealant (great stuff and the like) and sealed off the ceiling fixtures, where the duct work penetrates the ceiling, and where electrical cables penetrate the top of interior walls. Basically, anywhere that air can circulate into the attic from the house below. It's still a hassle to move the loose-fill insulation back, but since you're doing small areas at a time it's pretty easily done by hand. It's definitely worth your time to air-seal before adding more insulation. Create a map of all the ceiling fixtures before you start, and once you get oriented to where everything in the attic is it goes pretty fast.
A good book on the subject is 'Insulate & Weatherize: For Energy Efficiency at Home (Taunton's Build Like a Pro)'. I have the 2002 edition and highly recommend it.
Finally, you might want to consider installing a radiant barrier when you're done insulating. I installed one in my attic last year, and the difference is astounding. Using my handy laser-thermometer, the underside of the foil (I stapled it to the underside of the roof) is typically 15-20 degrees cooler than the underside of the roof. It can also be a lot of work stapling the foil to the underside of the roof, but you can also just lay the barrier over the insulation. Besides air-sealing, the radiant barrier is probably the best bang for your buck. I got 3000 sq/ft from
http://www.ecofoil.com/ for about $400 shipped, and I was quoted $3000 by a local heating/cooling company to have them install one. I'll be doing the same thing to my rental property to save wear and tear on the AC unit there as well.