It's the alcohol in Revolution or any other squeeze-on product that causes the distress for maybe 20-30 minutes.
Advantage "they say" is the mildest.
Advantage takes long to dry on the skin, and is more prone from my experience to be licked off if you don't manage to apply it correctly where it's supposed to go (my cats will NOT hold still like in the commercial).
Revolution is completely dry after a few minutes.
I have used Revolution these past two years, but only once in the fall, because it is also a dewormer and kills ticks (doesn't say so on the package, but fall is tick season here and I found a few dead ticks on my Bobby after applying Revolution).
I have two outdoor cats who hunt, so when it comes to all these products I use them as a strong medication when I feel it is needed.
Other than that I use a flea comb daily, depending on the weather fleas can get really bad around here, or almost dissappear when it gets really hot and no rain in the summer. I check for ticks daily, I read on numerous sources that it takes 12 hours for a virus to enter the cat's system once biten by a tick. I find ticks only in the fall, and that is also why I apply Revolution then.
I have experimented around with food grade DE, but that was a disaster.
Around here the fleas are immune to Frontline, hardly anyone still uses it.
It also kills ticks for one month and fleas for 3 months (according to the vets, says different on package).
Advantage will only kill fleas and from my experience lasts no longer than 3 weeks.
If I had indoor only cats I would use NOTHING but a flea comb if for some odd reason a flea found it's way on my cat's fur.
Just don't EVER use a flea collar or powder or bath, that's all chemical overload and can kill.
And also don't EVER use essential oils on cats, they can kill the cat even faster than chemical powder, they are often recommended for dogs and there are also flea collars with essential oils out there for cats I believe, but NO NO NO.
Here is a website that lists all flea products and their ingredients and how they are rated to be harmful to the cat:
http://www.simplesteps.org/greenpaws-products
If for some reason your cat is suddenly infested with fleas but normally not exposed to them (indoor only) a good solution (other than good old fashioned flea comb) is also IMO "capstar", they are little pills (really little and don't taste bitter, one can hide them easy in a treat or "pill pockets"), they will only kill adult fleas, not prevent a new infestation, they are considered mild and start working within the hour.
They are often the solution if you have a feral or semi-feral cat, that won't let you use a comb or let you come closer than a few feet, but if you have only one cat in the backyard you are feeding and can watch it eat, you can hide the pill in a treat and make sure he ate it.
I used that in the beginning every now and then when my cats were still feral and any touchy touchy was out of the question.
I feel you always have to decide what is best for every unique situation.
Not generally "everybody uses Advantage all the time so it must be the best".
Around the house I use a Dyson and a steam mop, period.