Still an honor. Daniel invaded a VERY private conference between System Lords and let his inner Good Guy out for too long to try and persuade another (I forgot the word for a human assistant that is supposed to act as an emergency host) into seeing their Gods as parasites. He revealed he was aware they aren't what they appear but still can't wait to be a Host because then he'll stand at the very top of their society.
TD;LR
Still an honor
"Lo'taur" were the human 'seconds'/emergency hosts, playing a large role in Summit and Last Stand toward the end of season five. Daniel only talked with Ba'al's Lo'taur, and he was somewhat more genre-savvy than the typical goa'uld, but
it did at least motion around around it :
Yes. Endless pleasure and the power of the Goa'uld. And the chance to one day ascend to the rank of System Lord.
Which... uh, may or may not be indicative of just a
different misunderstanding. If a goa'uld can experience and share interests with the goa'uld possessing them, it's a different matter than if they're locked in a cage in their own head. We get evidence pointing both directions, and to a large number of points in between.
The SGC have already learned that at least some hosts are basically trapped in their own body:
S2E17 talked about it as somewhere between a dream and a nightmare, and 'awakening' as Apophis was dying. And Kendra from the Thor's Hammer planet was able to retain enough knowledge from her time as a host to use a kara kesh, and claimed she was even partly able to trick her goa'uld into going to the Thor's Hammer world. On the other hand, Kawalasky from S1E2 didn't even know what his (a fairly young and poorly integrated) goa'uld did with his body. Skaara was able to overpower Klorel at points, but that almost never comes up with other hosts.
But we don't get much other information (Vala shows up in mid-Season 8 as another ex-host that retained goa'uld knowledge, one rando in Atlantis got goa'uld'd until it was tasered into submission), and SGC has basically none of that, and it's unclear how much difference there might be between one goa'uld and another.