From a user perspective, they are given a radio and usually given an explanation of where it can be expected to work. They turn on the radio, set the knob to their channel and just expect it to work.
Let's say there are 3 traffic signal repair guys that work for Main County which are the only users of Talk Group 123. The P25 system spans the entire state. Main County has 3 sites. The system is configured to only allow Talk Group 123 users to operate in Main County. On Monday all 3 repair guys are working the same job and therefore only the closest site needs to carry their traffic. On Tuesday each of the 3 guys are at the 3 farthest edges of the county, so all 3 sites carry their traffic. On Wednesday, a worker that lives in Hick County calls in sick, but attempts to use his radio from home to get in touch with his colleague. He gets a BONK tone and NO SERVICE when he turns on his radio. This would be a typical configuration. A more critical user such as a Police Officer would likely be able to use their home talkgroup anywhere in the state, due to police chases, prisoner transfers, court, etc.
In another county, 5 volunteers firefighters go home to a different county each night. Instead of being able to take their expensive P25 radio home, they are issued a Unication Pager. Since Unication is receive only, it can't tell the local site which Talk Group it wishes to listen to. So the radio shop has made a special configuration for Fire Dispatch to always be carried on that site, regardless if any actual P25 radios are affiliated with that group on that site.
There are also simulcast sites which carry the exact same transmissions on the same exact set of frequencies simultaneously on all participating sites. It really just comes down to design and various needs. One reason to use a simulcast over multiple locations is maintaining only a single set of frequencies, versus having to maintain frequency allocations for each site. You can maybe get 10 frequencies to support the entire service area, versus 5 frequencies for each site. It all comes to calculating load factors. While towers in the simulcasts sites are geographically distributed, conceptually they are just another site that serves a given area that a user can roam to.