Answer is....it's depends. Bunch of factors including why you were whammied, where you came from, what you owe the Navy, and most importantly, the Needs of the Navy (tm).
Edit, I should say I've seen dudes I know go Civilian, SWO, OceanO, MSC, and SuppO. A few of those were good deal transitions. A few were not.