A throttles a throttle, with a number of axes, and varying build qualities, and prices to match.
The game you use it with shouldn’t matter. That said, some might “feel” better. Like in Elite, my Warthog throttle is better suited than my TQ6+. Both would work adequately, but Elite doesn’t really need another 5 levers.
I suppose out of the two, a multi-function throttle with lots of additional buttons, and switches would arguably be of more use across different genres of game.
Unfortunately, a lot of those types of throttle don’t tend to be sold on their own, like the Saitek kit, where you get the stick as well. You can get the Warthog throttle stand alone.
What do you want to use it with?