Incompatible Software for next OSX?
RoaringApps has an incredibly thorough chart of apps and the various OS versions (OS X, iOS, and Windows!) that they're compatible with.
For reference, a green circle means an app works fine, a yellow circle means it works with some problems, a red circle means it doesn't work, a gray circle means there's conflicting data, and a blue circle means there's no data.
Re your complaint about searching many apps: They're working on a Mac app that'll scan your computer and give you compatibility reports for every app you've got.