I think my main Dragonborn would be fairly happy in Proudspire Manor, though I think he would be happiest in a nice cottage with a warm fireplace and a large library. I think it would be cool to be able to build a small village where the Dragonborn and his closest friends could reside, especially since I have several OCs I imagine who resolved the Dragon Conflict as a team.
Also, imagine rebuilding Helgen and making it into a large home for you and your companions! What a fitting home for the Dragonborn and his/her friends!