I visited South Queensferry yesterday. It really is charming around the old High Street with a selection of specialist shops and the views over the Forth Estuary and the bridges. There are a fair number of pubs, cafes and restaurants.
View of the 2 Forth Bridges
You can cruise on the Maid of the Forth over to the island of Incholm and visit the abbey.