did palpatine really have that much faith in his employees that he would visit and stay at the death star II ?

As shitty as the premise of him coming back in the that travesty of a sequel was, what you pointed out actually does add some support to the notion that it was planned.

It doesn't make those terrible new Star Wars movies any better, but well done for thinking of that.

The dude did shoot his mouth off about his grand sith fleet about 24 hours too soon, so its not like he was the smartest sith on the banana tree.

Little known fact that death stars have hotels that put the Waldorf Astoria to shame.

Ignoring the Sequels:

It was additional bait to the Alliance. Of course they would try to attack the Death Star before it was operational, but with him on board they would send everything they had to ensure the ultimate victory. Thus, putting their entire fleet in the mouth of his trap.

And he knew Luke would be there and be drawn to Vader. So this would give him the chance to turn Luke to the dark side.

Yes, it was established while writing this movie that Palpatine would eventually return in a future episode

My impression was always that the Emperor had lost all faith in Darth Vader to get the job done and so he was gonna supervise this one personally. He knew his kid was in play too and Darth's head would be all screwed up. Pulling from the prequels, Anakin's flaw was always a weakness for family and Palpatine knew this. But ignoring them, he's simply a screw up. there's no way in hell the Emperor didn't feel Yoda and Obi-wan's meddling. The Force goes both ways. He knew it was a potentially dangerous move. I've said this for years but Lando is Force zero, where as Han stinks of the stuff. Lando and the Falcon was a total wild card that the Emperor could not detect. End of the day, Obi-Wan's gambit succeeded. He raised Luke as an innocent lamb and dumped him into a slaughter house knowing Anakin would finally do the right thing because he f'n knew that kid.