That was the event of the year 2018: Paul McCartne...

That was the event of the year 2018: Paul McCartney at the SSE Hydro in Glasgow. Good sound, clever seating architecture, easy access to indoor catering and a good mood among the Scots. Less enjoyable is the access, because the signage is designed Scottish stingy. You also have to know the entrances or ask the consistently nice Scots.
From Germany you can get there quickly by plane, you find a cheap hotel on the search platforms (eg Lorne Hotel). The public transport is great, the Uber- prices are a temptation.