If your destroyers are limited to the Gallente destroyers, then I think you could safely strike the Eris from your list. The Gallente interdictor is decidedly unpopular.
I know of a few people who enjoy the Hecate, but as a T3 it is a rather pricey option and they usually use it for PvP. If you like fleet ups and don’t have someone flying a command ship, the Magus could be something your fleet mates appreciate. The algos is a dependable, relatively inexpensive, easy to fly drone boat and the catalyst has lots of guns for not much money if that’s appealing to you.
Eve University has a summary and collection of sample fits for many craft, though you would want to double check that these crowd sourced fits are still valid in contemporary Eve. No telling when they were last updated.
If I were you, I’d try them all, or at least all you were interested in. Also, if you put a finer point on what you like to do in Eve and with how many people, people may be able to give more specific advice for your specific situation.