What is the end state of a starship that has been assimilated by the Borg?

Question

In this answer to Why do the Borg have physical computer interfaces?, the poster states:

As mentioned by MarvelX42, when assimilating a ship that uses screens, it makes sense to just keep using those screens rather than to re-program the whole ship to bypass them. This is especially compelling since we see "Borg consoles" much more often on assimilated ships, like the Enterprise-E, than on native Borg constructs, like the Cubes, where Drones are more commonly locked into their docking stations.

What is the final or end state of a starship of non-Borg origin that has been assimilated by the Borg? In First Contact, we see an attempt to assimilate the Enterprise-E in which the Borg interface their own systems with the Enterprise's existing systems, but the attempt is stopped before it is completed and so we do not find out what would have happened if it had been completed.

When a ship has been fully assimilated, what happens to it?

• Is it converted into a Cube or other Borg ship design (e.g. existing Cubes might have remnants of whatever ship they were originally deep down somewhere in their cores, or they might become Cubes of Theseus)?
• Does it become a Borg-mod version of whatever ship it was originally, with many of its original quirks preserved (e.g. somewhere out there in Borg space may be Borgified Cardassian Galor-class cruisers, Klingon Birds-of-Prey, etc., assigned to less-important patrols and missions that do not require the full might of a Cube)?
• Is it flown to the nearest Borg base and disassembled for parts or materials?

Is this ever explained at any level of canon, including novels?

Answer 1

Before

After

Arctic One, seen in an episode of Enterprise, is an example of a Borg-assimilated ship.

From Arctic One's Memory Alpha entry:

In the writer's commentary for "Regeneration" on the ENT Season 2 DVD, the episode's writers revealed that the reason the ship's mass kept growing was that the ship would have eventually evolved into a Borg sphere, implying that the Borg don't have traditional shipyards, but instead take ships they attack and assimilate them. This information wasn't conveyed in the episode, however.

Because it wasn't actually shown in the episode, whether this information represents Star Trek canon remains to be seen. Taking the quote at face value, however, any assimilated ship would just get added to an built up until it eventually becomes a sphere or cube.

Kind of makes you wonder if the unusually-shaped "Borg Scout" used by Hugh et al. was a similar "conversion" in early stages of growing into a sphere or cube.