Until the last episode I was confused too. I didn’t get into my favorite character at all in season 4, but know I think I understand what is driving him mad and the reason is simple, cause we all know his drive. He just want his son. He wanted him in the first minute when the seer told him about Bae and he still wants his son after he is gone.
I think resurecting his son would be his favorite option, but he knows that it would be never his Bae. It would a marionette ( a Zombie like David, or the ones Cora and Jafar were using) and not the brave boy he loved so dearly.
My guessing is that he will destroy Storybrook and kill all person in it, to wipe out his past so it can’t haunt him for the future he wants to build. He will have his wife Belle, his grandson Henry and his power to protect his little world that are not more then his family. Rumplestiltskin never cared for the world he just needed all informations and power to find his family, to protect it at all costs. This is the spinners core and will it ever be. The rest of the world even if he like a few in them can go to the purgatory if needed.
I think that Rumple will even go further than that. We (not) know about the deleted Grandpastiltskins moment in season 4 that even Henry wants his cursed memory from NY back, cause their he was happy. I believe that Rumple will give it Henry back with one minor change, so that Henry can be his son. He will try to create his perfect fresh start that he ever wanted.
You know guys that sometimes he is just too weird like asking his son to change 14 again after seeing him not a couple of hundred of years.
Heros don't get their Happy Ending!