I haven't tried it, but I don't like being bothered with extra stuff, I can't even imagine my mother dealing with this stuff.
If we can't simplify our users lives, we have failed. Is security hard? Hell it is. But we can do better and we MUST do better, for the love of science.
First, this is optional, so no one who doesn't want it has to worry about it. If you aren't worried about your google account being hacked, then don't enable it.
Second, can you really think of a better option? Two factor authentication like this has been used by high security institutions for years and it works quite well. Personally, it has bothered me for years that my bank does not use 2-factor identification to log in... I am certain there is plenty of room for improvement, but it is certainly non-trivial.
If we can't simplify our users lives, we have failed. Is security hard? Hell it is. But we can do better and we MUST do better, for the love of science.