Hoid is no stranger to overarching plans- his presence on Roshar is for one, a single, Stormlight-related plot goal. He is confirmed to possess a plan, when in Secret History, Hoid says to Kelsier:
Neither Leras or Khriss give hints away, other than that Khriss considers her task futile when she hears he took the second to last Lerasium bead- but Hoid's search of adding new magic systems to his portfolio always seems secondary. Other than the theft of the lerasium, we know three things Hoid was doing during era 1.
The first is that Hoid was a successful informant in Luthadel during TFE, one known to both the nobility and rebellion, who dealt with both, and was successful enough he was smoking tobacco, a high-in-demand luxury item on Scadrial. The only thing that seems notable here is that Hoid either doesn't know about House Renoux being a front of the rebellion, or he's trying to dissuade Kelsier in the guise of a nobleman from peering too closely into Renoux.
The second, during WoA, is that he is primarily in Terris, not trying to get Feruchemy, but investigating it, because he has a power that is similar to Feruchemy, and he is attempting to secure guidance from the Synod and the Keepers. With the Razing of Tathingdwen, he ends up wrapped up in the event, and becomes the leader of a group of Terris refugees, securing their safety.
The third, during HoA, is that he is doing the successful informant thing again, in Fadrex City- successful enough that the King of the Dominance, Ashweather Cett, encouraged Vin to seek him out for information, but the two never meet, as Kelsier guides her away from Hoid, and Ruin is unaware of his presence in Fadrex.
Now, what was this plan? The biggest thing Kelsier did was overthrow the Final Empire, and pave the way for the death of the Lord Ruler- so Hoid was planning for him to die- but for what reason? I've seen speculation that the plan was to grab the lerasium and run, but if this was true, then Hoid would get the hell off of Scadrial, as opposed to sticking around after the Well of Ascension is emptied and there are no viable ways of getting off world. Hoid knew Scadrial would survive, and stayed on the world until the Catacendre. Leras states that he and Hoid were not in contact in the past few years, so Hoid possibly doesn't know Preservation's plan, but he has been on Scadrial before- the Terris Worldbringers was either founded by Hoid or someone influenced by Hoid. It's possible his plan was Preservation's plan, and he was aiding him secretly- and that seems the closest, but Kelsier was integral to the success of Preservation's plan, so why was he ignored by Hoid?
Pre-Roshar, being a subtle actor is what Hoid's best at, and I have no doubt he used this to nudge rumors and people towards certain actions, and this made up a majority of his subtle influence on his world, but I am clueless about his ultimate plan- other than it does not involve the destruction of Scadrial.