The Orca is made to support miners. It can run mining gang links, has huge tractor bonuses, a massive cargo bay, a solid drone bay (5 mediums). The corp hanger allows the miners to drop the ore directly in the ship without needing to do a hand off. You can hold ~150k m3 of ore if you fit it for max cargo as it has a 50k m3 dedicated ore only hold on top of the corp hanger and cargo bay, and you can even shove 2x hulks in the ship bay.

I use mine as a mini freighter in high sec. Slap a MWD (needs a grid mod of implant) on it and it can align off of a gate in 10s.

I'm not sure what else you'd need in a support ship, but you wont find much better unless you step up to Rorqual.