Ok, I will list a few, and get back to post links...
Trainspotting: Exploring drug abuse in Edinburgh, and it's impact on a group of friends.
http://en.wikipedia.org/wiki/Trainspotting_(film)
My Name is Joe: A recovering alcoholic tries to carve out a new life for himself, and come to terms with the demons of his past. Very good film.
http://en.wikipedia.org/wiki/My_Name_Is_Joe
Local Hero: I have not seen this, but it's supposed to be very good, it's about some American developer coming over and trying to buy up a small town(IIRC)
http://en.wikipedia.org/wiki/Local_Hero
Restless Natives: I don't know if this will suit your purposes in regards to a serious discourse, but I had to mention it as it's a great Scottish movie. Two naive friends become folk heroes when they start dressing up as a Clown and a Wolfman and holding up buses, using weapons furnished from the joke-shop one of them works in.
http://en.wikipedia.org/wiki/Restless_Natives
Ratcatcher: Pretty interesting film about a working class community during the refuse workers strike of the late 70s, hence the rats of the title.
http://en.wikipedia.org/wiki/Ratcatcher_(film)
Gregory's Girl: A coming of age story set in a Scottish secondary school, about a guy, who plays in goal for the school team, who falls for a girl who ends up playing in the school football team. If you have not seen this movie, I highly, highly, highly recommend it, it's hilarious, really great.
http://en.wikipedia.org/wiki/Gregory's_Girl
Small Faces: about the gangs in 1960s Glasgow.
http://en.wikipedia.org/wiki/Small_Faces_(film)
16 years of Alcohol: another grim but great movie about a Scottish alcoholic. I have not seen all of this movie, but what i saw of it was very good. I put the dvd off for a break as it was pretty grim, and never got round to watching the rest of it before my mate took his dvd back, lol. Directed by Richard Jobson of the punk band 'The Skids'. He was mentored through the project by some accliamed Japanese film director just before he died iirc.
http://en.wikipedia.org/wiki/16_Years_Of_Alcohol
The Acid House: an adaptation of Trainspotting author Irvine Welsh's short stories, 3 of them. This is ok, worth a watch if you are interested in Welsh's stuff, but sometimes feels like it was made for tv.
http://en.wikipedia.org/wiki/The_Acid_House_(film)
Braveheart: Conan the Barbarian buys a kilt, paints his face and moves to Scotland. Starring Mad Mel Gibson.
http://en.wikipedia.org/wiki/Braveheart