From what I read his "powers" don't stay they come and go every episode so if they come at random we could have plenty of funny things.

I think you'll find is that items in the "Intersect" are in Chuck's subconscious mind and once he flashes either because of face, photo, number, or some other stimulus what ever he flashes on becomes part of his conscious mind and never leaves him. For example he knows Kung Fu from now on. Remember what he said "Guys I know Kung Fu". I figure the Intersect was made to flash on only bits of information at a time because to know everything all once would be overwhelming to anyone. We also know that being a human intersect is not something everyone can do because in Chuck Vs the Suburbs the intersect Fulcrum tried to use killed some and turned others brains into mush when Casey turned it on, which the new one might have done to Bryce had he lived to try it.
Also remember that Chuck had the special ability to recall bits of info when he was at Stanford and the Professor tested him and others. Chucks test score for recall of massive amounts of information was 98% and that was why his professor was going to try to recruit him.

i wonder how chuck's character is going to change? since he'll have no reason to be frighten, clumsy and non-spy stuff as much? also i believe that he'll be able to 'flash' all possible knowledge convenient for solving any issue without help.. he is turning into superman and i expect some serious world spinning!! but i really wonder how they gonna make it interesting... but they are all GREATEST!!!