Hi! I noticed you posted this a while ago so you may not need any input anymore but thought I’d reply anyway.
I studied at Stirling (just finished my final year) and I rly enjoyed it. I have never been to Dundee so I am useless there but can share my experience of Stirling.
It definitely depends on your course, however my course at Stirling is not highly regarded in league tables etc but I found the teaching incredible. All teachers were very approachable and always willing to help. The content of the course was probably a bit too simple and I imagine another uni would have taught me more but I still loved the experience.
The campus is gorgeous and so is the town however it is definitely quiet and there is not much of a night life so if that is a priority for you Stirling might not be the place! There are a couple of night clubs but if people are looking for a good night out Edinburgh and Glasgow are close by train.
I have lived on campus and in town and felt very safe both places. Halls can be a bit noisy but I was an undergrad so expected it and it rly wasn’t too bad.
Sorry if you have already made your decision but if not I hope this helps!