I haven’t seen it posted, but my favorite ship has been, for a very long time, the Miranda Class, first featured in Star Trek II: The Wrath of Kahn.
It looks good, to me, and the lore surrounding it tends to paint it as a not so glamorous workhorse. It was easy to construct, customizable, and reliable, and commonly in active service to Starfleet for around a century.
More than flash and fame, I admire that which serves quietly with no expectation of glory. That which can be counted on to do the jobs that need done, but for which there is no promised reward beyond the completion of the task.
