Kaitu: Mostly 2D (looked like Rogue Legacy is a Xinput title since the buttons were preassigned). Maybe a 60/30/10 split between 2D/3D/Flyers or somewhere in that range.
AFAIK Rogue Legacy supports both and the Logitech supports both so you definitely shouldn't run into problems there.
For 2D platformers I'd say the d-pad is a priority.
Looking at it though, the Logitech d-pad looks a bit dodgy but I've not actually used one so I can't be sure. It might just be my personal preference, it seems to use the "rocking circle" design that I'm not fan of (I prefer Nintendo style + d-pad followed by the Sony style split +).
I digress, just try and have a go on one before you buy to make sure you get on ok with that style of d-pad.