With the government of both the UK as a whole and Scotland basically opening things up and free LFTs going away, I essentially don't trust the case counts any more. They're going down, but it's impossible to tell whether that's from people doing less of them rather than cases actually dropping.
Fortunately, we have the ONS survey! They talk to the same people every two weeks (180,000 of them), and get them to do a test. This allows them to track across a fairly stable sample of the population and extrapolate how many people actually likely have Covid. You can read about their methods
here.
As you can see in this image, the infection rate went *really* high in Scotland - 1 in 11 people had it at the peak last month.

Thankfully it's been dropping since then, even if it's still remarkably high compared to any previous time period.
The other thing I trust is the hospitalisation figures:

Where, again, you can see a massive peak, but this is now dropping quite quickly.
So things have been pretty bad, and the hospitals got a little scarily full, but it's all now moving in the right direction again.
As a note, the two peaks are almost certainly Omicron and its BA.2 subvariant. Fingers crossed for no more subvariants with exciting mutations!
Finally, I was fascinated to see this from the ONS, which details the total percentage of people in each nation of the UK who have had Covid:

Fascinating that Scotland and Wales have had a chunk less infections than England/Northern Ireland. I wouldn't like to comment on why - but I assume that different approaches and different population density would both play a large part.