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.