I really liked Robocop, in particular exploring the concept of coping with being a cyborg. The sequel was cheesy, but it looked at the type of people who could handle being cyborged- Alex Murphy was able to withstand the procedure because of his dedication to duty. Cain was able to survive it because he had a God complex (and a Nuke addiction).
Would you be able to handle having your brain stuck in a killbot? Back when I was an angsty teenager I would be able to handle it. Back then I had a lot of power fantasies and the idea of having a shiny new killbot body would be appealing. But now? With a wife, a job I like, and a better relationship with my family, being a killbot would be depressing.
My hoplesness would be channeled into anger, and like other killbots before me, I would probably go bersek eventually, turning on my creators. 
It would probably turn out badly for the next insolent little nebbish that dares speak back to me in the classroom. I can dream, though…
It depends on a lot of things, how advanced is the tech, do I lose some range of my senses and tactile feelings or are they enhanced, how much maintance do I require, am I still able to experience that strange human emotion called ‘love’, not to mention being physically capable of getting it on, and probably most important, do I look cool? 
As much as I’d like to change my body and appearance (no real self-hate body-image issues, just think being stuck in one body and looking the way we do throughout our lives is pretty restrictive, I’ve read too much science-fiction…) I don’t think I’d give it a go unless I was getting old or was badly injured and a new body would be an improvement.
Is it a total body conversion or can we upgrade body parts at a time, like Tycho Brahe, the worlds first cyborg?
So basically to narrow it down to two examples, Robocop style cyborg (major less of physical humanity) nope, Ghost in the Shell style cyborg (although with some restrictions pretty much an overall enhancement of the human body) I’d probably give it a go.
Actually, I could totally go for an Adam Jenson in Deus Ex style cyborg upgrade.
Well that was incoherent, thats what you get for rushing things…and not having an incredibly fast massively-parrallel processor embeded in my brain…
btw I hear theres a new Robocop movie coming out, hopefully they can fulfill the concepts potential as they did in the first movie.
Hear it’s a reboot. Joel Kinnaman is on board to star as Murphy/Robocop.
I like how it was handled in Deus Ex. Your character is one of the two nano-augmented cyborgs. Two of the older mechanical cyborgs you work with have serious inferiority complexes and treat you like crap. They are entering obsolescence, while you are not only new, but can easily upgrade yourself through augmentations. And your character treats all this as matter of fact rather than a major revelation, including the possibility that his childhood pre-cyborged memories are all false.