For understandable reasons, the majority of the "hero ships" in Starfleet are multi-role platform (the only partial exception to this is the Defiant, but even that can do some limited recon, priority courier and (very limited) diplomatic hosting at pinch), however we have occassionally seen examples of ships that were either built as specialist platform or were relegated to secondary roles (in peace time) as they got older.
The earliest (retconed) example of this would be the Antares from Charlie X (later reused as the Woden), although it's still dual-purpose as although it's primarily a cargo transport, some hulls have also been fitted out as a civilian surveyor. The Erewhon-class appears to have been a/the 24th successor to this design and may have been inspired by the UESF/ECS Conestoga-type colony ship.
The Hiawatha-type is apparently a dedicated medical ship (oddly a frigate, which is normally a warship, but may refer to size/tonnage/speed), as is the later Olympic-class vessel, which at least in TrekLit was potentially going to be replaced with the Galen-class
.
Some Miranda-class vessels were also relegated to civilian supply or surveyor duties, though this seems to have been on a case-by-case basis as of the three oldest 24th C hulls (Antares, Lantree and Trial), only Lantree is suggested as being demilitarized, though most of the others were used in taskforces and fleets suggesting that unlike their larger Excelsior cousins, they couldn't keep place with the requirements of a solo starship into the 24th Century.
However, my favourite "single purpose" ships are Full Circle's support vessels - Achilles, Galen and Demeter - particularly the first as I think it has a lot of potential as effectively a "mobile starbase" and if constructed in bulk (tricky given it's vast size) could easily serve as a flagship for it's own fleet of runabouts, surveyors and escorts and is probably the closest to a modern (super)carrier of anything that we'veseen in Star Trek outside of the games (the Akira-class is more of an "aviation (battle)cruiser" given that it sits within the normal size range and is heavily armed in addition to (theoritically) carrying fighters/tactical shuttles.
Any thoughts
The earliest (retconed) example of this would be the Antares from Charlie X (later reused as the Woden), although it's still dual-purpose as although it's primarily a cargo transport, some hulls have also been fitted out as a civilian surveyor. The Erewhon-class appears to have been a/the 24th successor to this design and may have been inspired by the UESF/ECS Conestoga-type colony ship.
The Hiawatha-type is apparently a dedicated medical ship (oddly a frigate, which is normally a warship, but may refer to size/tonnage/speed), as is the later Olympic-class vessel, which at least in TrekLit was potentially going to be replaced with the Galen-class
though with the loss of the prototype this may now be in doubt
Some Miranda-class vessels were also relegated to civilian supply or surveyor duties, though this seems to have been on a case-by-case basis as of the three oldest 24th C hulls (Antares, Lantree and Trial), only Lantree is suggested as being demilitarized, though most of the others were used in taskforces and fleets suggesting that unlike their larger Excelsior cousins, they couldn't keep place with the requirements of a solo starship into the 24th Century.
However, my favourite "single purpose" ships are Full Circle's support vessels - Achilles, Galen and Demeter - particularly the first as I think it has a lot of potential as effectively a "mobile starbase" and if constructed in bulk (tricky given it's vast size) could easily serve as a flagship for it's own fleet of runabouts, surveyors and escorts and is probably the closest to a modern (super)carrier of anything that we'veseen in Star Trek outside of the games (the Akira-class is more of an "aviation (battle)cruiser" given that it sits within the normal size range and is heavily armed in addition to (theoritically) carrying fighters/tactical shuttles.
Any thoughts