Probably good to remember that even if you were in the top 10% of popular creators on Tapas, your life probably wouldn't change much. With comic artists and novelists, you really do need to be in the top 1% of the industry to really experience the kind of fame people are talking about here, like widely televised interviews, or really intense discourse on social media that could lead to some people declaring your work "cancelled" kinda thing...
You can be earning a pretty good income from your comics and/or novels, or have been published by some big deal publishers and stuff, and it really won't be like being a Hollywood or TV star. There won't be Paparazzi, nobody will recognise you in the street, your social media following might increase, but it won't explode.
It's really not worth being scared of, or not making for fear of it. Even if the film or TV rights to your work were sold, you probably still wouldn't get recognised in the street. And if you were really scared of that, you can always do a Toby Fox or Hiromu Arakawa and simply have it be one of your quirks that you always appear hidden in some way in publicity photos or as some sort of character. Plus if you were that famous, you wouldn't really need to be on social media all that much, and could hand it off to a manager.
Most comics creators simply don't reach that ridiculous level of popularity though. I regularly chat with people who have a few published books out with good publishers or tens or hundreds of thousands of subs, or who have done work with Marvel or on TV stuff, and they don't get hounded nearly as much as you think. I've done work on Doctor Who stuff myself, and the response is "oh cool" because like... practically every pro comic artist in the UK seems to have done something on some kind of Doctor Who stuff. I've done a lot of interviews with comic blogs and newspapers and it's like... yeah, that's normal, nobody cares. Last Thoughtbubble, I was sat next to a Marvel writer who'd done some pretty high-profile books, and while her table consistently had people at it, it wasn't like Beatle-mania or anything with hordes of screaming fans. When I wandered over to Kit Buss' table, I thought I'd have to fight my way there to chat to my old comics scene friend because....it's Kit Buss, she did the character art and designs on the first season of freakin' Critical Role, but nah, I was able to just swing on over and say hi.
You seriously, literally do need to make a comic or novel with a readership in the million to get the kind of fame where everyone's constantly crowding around you and the paperazzi are remotely interested. It's really not worth worrying about because it's extremely rare. Most artists who are even considered "successful" and have long, successful careers won't experience it.