Iain Banks' The Bridge is pretty good, as is The Wasp Factory. Something else you might like, which kinda-sorta follows on from Merc's recommendation of the Peter Grant (a recommendation that I wholeheartedly second), is Christopher Fowler's Bryant and May books, about two octogenarian Met detectives solving crimes in London. The supernatural is touched upon (the titular Bryant is rather obsessed with the occult; his partner May, er... not so much) and a lot of the crimes involve a slew of occult and magical references, but it's all very much rooted in the real world and the real London. They're wonderful, hopeful, triumphant stories. They are also my leading cause of laughter-induced spit-takes.

---
"Yeah, I'm definitely going to hell/But I'll have all the best stories to tell" -- Frank Turner, The Ballad of Me and My Friends