Read the Rebus series by Ian Rankin, instruction book . Or Val McDermids stuff. Surprisingly both Jockanese, one Edinburgh one West coast but both surprisingly clued up on the more grim sides of life!
There's an entire genre called Tartan noir.
The stories are indeed grim and lifelike.