Places that I’ve found are good or bad, (mainly the former):

Edinburgh (Castle et al)
Stirling Castle, Jail, and Wallace Monument
Fife
Misc places in England (inc. Jovik Viking Centre)

Advice to visitors:
Do like Billy Connolly says - if you visit Scotland, don’t just visit Edinburgh and then leave! Go to the other parts as well. For example try Fife (just across the River Forth). If you’re missing the bright lights, try Glasgow. But bring wet weather gear as it has been known to rain!