Was hoping if I could get some opinions on this trait? Has anyone used it before? What are some clever ways to use it? Will it be of any use later on in the game after we move to the big city of Magnimar? Not looking for any spoilers, just opinions.
There is no "best" campaign trait. Whether or not you take the trait should depend on whether or not you want your character to have a close friendship with Sheriff Hemlock (and what impact that might have on your character's outlook and actions.)
We're still only in Chapter 2, but the PC in my current group that is getting the "most" out of her Campaign Trait is the rogue with Favored Daughter: Ameiko. But that's more because the party spends a lot of time in The Rusty Dragon and having Ameiko as the rogue's "besty" has made for some great RP moments.
As always, your mileage may vary, because it's up to your GM how prominent a role Hemlock will play in the game.
As with everything else, this is a question best asked of your GM. Only he knows what prominence he's going to give to what NPC (the AP has dozens of NPCs in Sandpoint. Different campaigns are going to have a different focus. One of my current PCs is a reformed smuggler turned priest of Sarenrae who is friends with both Naffer Vosk, the gravekeeper and Gorvi the dungsweeper. Both those NPCs have much more prominent roles in this campaign than they did the previous time I ran it, where they were barely mentioned.)
Hmm, will we always come back to Standpoint even later on in the campaign? I guess that is my concern. Or is it only during the early and mid game that we are in Sandpoint? I figure if we are going to leave permenantly it may not be a good use of a trait, I may be able to get better value elsewhere.
That goes back to "ask your GM". If we answer "yes' or "no" on the message boards, that IS a spoiler. How bad of one depends on how open your GM wishes to be with the projected plans of the AP.
But, yeah, that's one to ask your GM.
Oh ok thank you. Ya no spoilers, thx.