O_o
It is not like Notch or Mike Bithell or people like that are exactly rock stars in Reallife.
Outside of the Indie Gaming scene, which is still a small, quite vocal, but still small subscene of the whole gamer world, not many people will know them...
There might be the odd article about Notch in a magazine... people might remember "That guy that made millions with a weird blocky game... what was his name again?"... and the next day they will have forgotten that they ever read about the person, because their mind has been flooded with o so important and interesting facts like the small finger mutation of Megan Fox, why Pharrell Williams seems to be glued to his hats and other things that shake the world (not).
Chances are, you make it "to the top", are amongst a very narrow group of indies that can pay the bills with the income generated by their games, maybe even get a good income at that (though most probably the average stock broker income will still be out of reach by far... getting rich as an indie is just as hard as getting rich as a rock star).
Still most of your friends will only know what you for a living when you tell them. Chances are most of them have only played your game because you sent them the link, and maybe even then just because they wanted to be polite, you being their friend and all.
You might get a small die hard fan group. Maybe even a big one. That is vital for success. Don't expect them to be your friends though, they are not. A lot of stars will tell you that.How you deal with stalkers, groupies (are there even "game creator groupies"? Should I be afraid to ask for a pic? ), and fame in general is something you could turn to music and movie stars, they have their share of it. Still 99,9999% of the people working as musicians or actors try to get more of them... or rather, more of the fans... because without them, you are no one in the showbiz. If you are no-one, nobody is interested in your products. Sad but true.
It might work a little bit different in the game industry... still, EA sells truckloads of their latest games even if they are bad (granted, they will have sunken multiple millions even into the 15th copy of the original FIFA Game ), yet loads of indie games that are extremly good still leave their creator with a day job to pay the bills.
Its the higher budget, its the marketing, but it is also the name of the creator that sells games.
I wouldn't worry to much in your case. If you expose your person during the marketing campaign, or find another way to make people relate to your game in a positive way matters little. Making sure your game is not the 1000th combat-puzzle-strategy-shooter released on platform X on the same day can be achieved by relating it to your person and making sure you present your person as something people are interested is just one way of achieving that goal.
Also be aware that a lot of the "stars" of this world use fake names, Nick names, fake personalities, masks, whatever to somehow separate their public and private personaes (with mixed success)... doing something like that seems to be a sensible approach for multiple reasons.
That is what you always do in a professional environment: You never reveal all of your private opinions and... ehr... quirks because it might offend someone, it would not fit the professional environment and you might not want to tell it someone other than your closest friends.