For example, take Underworld Connections. These aren't Orzhov mobsters or Dimir thieves. They're just ordinary Ravnicans, trying to make their way in the world by shopping in a dangerous black market bazaar.
Some of the unguilded have made peace with their lot in life. There's a lovely inn on Oak Street (or so Oak Street Innkeeper implies) where creatures of all guilds are welcome.
The guilds have had their enemies for some time. Back in Dissension, the Enemy of the Guildpact was the spirit of someone who hated guilds so much that it fought them even after death!
In Gatecrash, the defender of those without guilds is a noble Angel. That seems more uplifting than a spooky killer ghost, doesn't it?