I can’t think of any good jokes about the fact that this page even exists. Fortunately, Adobe wrote one for us. Regarding Flash Player:

Flash Player may cause higher CPU activity when playing a YouTube video.

On a serious note, I’ve been using Photoshop CS3 and InDesign CS4 on the Lion betas for months and have not encountered any issues whatsoever.