The Glasgow effect is fascinating, we've known about it for a long time but explanations are subjective and challenging and action to address is is consequently difficult. Just for comparison, both the drugs and alcohol stats give breakdowns by council so I've looked at these and posted some info below.
According to a quick google these are the populations of the major city councils
Aberdeen = 200, 680
Dundee = 148, 710
Edinburgh - 524, 930
Glasgow = 633,120
Drugs Deaths in 2019
Aberdeen = 44 (220 per Million)
Dundee = 72 (486 per million)
Edinburgh = 96 (183/million)
Glasgow = 279 (441/million)
Alcohol Deaths in 2019
Aberdeen = 32 (160/million)
Dundee = 32 (216/million)
Edinburgh = 80 (152/million)
Glasgow = 165 (260/million)
Overall scottish population is around 5,454,000.
2019 alcohol deaths = 1141 (209 per million)
2019 drug deaths =1264 (231 per million)
Obviously looking at just the city councils doesn't give the full picture, especially for Glasgow where a lot of the suburbs that you'd still consider "Glasgow" in general terms are in other council areas. For drugs they actually give the deaths/100k for every council area based on a 5 year average, so it's lower than the figures above due to the current rapid rise. These are the council areas which are at or above the national average:
Dundee City
Glasgow City
Inverclyde
East Ayrshire
North Ayrshire
Renfrewshire
Aberdeen City
West Dunbartonshire
Clackmannanshire
North Lanarkshire
Falkirk
This to me shows two things - the Glasgow effect is alive and well, especially when you look at the list of the wider council areas as there's a pronounced Glasgow/West Coast bias there. But also; is there a Dundee effect too? I don't know what the overall death stats look like but the drug stats in particular are pretty grim.