Merseyrail offer by far the best late evening rail transport of any Northern city, with the possible exception of Metrolink who offer later services (with last trams departing 0030 - 0100) on Friday and Saturday nights only.
Metrolink and Merseyrail are also the only ones that do not cut frequency of the evening service too. The standard pattern runs right up to the last train.
I will give you a good example - Manchester to Rochdale has a daytime frequency of 4tph. After 2000:
2025
2101
2126
2226
2250
2321
And that is one of the better ones.
Manchester to Marple is usually 2tph, but 4tph run for several hours in the evening peak. After 2000:
2045
2149
2249
2324
Leeds to Garforth has 3tph with more in the evening peak. After 2000:
2052
2150
2300
Liverpool to Wigan has 3tph during the day. After 2000:
2030
2047
2147
2302
Leeds to Hebden Bridge is 4tph during the day. After 2000:
2005
2035
2108
2135
2235
The final service from Manchester to Pemerton, Orrel, Upholland or Rainford is at 1747 from Manchester Victoria. The final service to these stations from Liverpool, with a change at Kirkby, is the 1835 from Liverpool Central.
The last train from York to Hull is at 2229. The last train from Leeds to Hull is at 2220. The last train from Hull to Driffield and Bridlington is at 2148. The last train from Hull to Cottingham and Beverley is at 2300. The last train from Leeds to Knaresborough is at 2129. The last train from Harrogate to York is at 2105. The last train from Newcastle to Cramlington and Morpeth is at 2200. The last train from Carlisle to Haltwhistle, Hexham and Newcastle is at 2125.
In the case of Northern, many of these are to be improved. Some are not to be improved at all, or are only moved a few minutes later.
I don't know where you got the idea that it isn't very good from. It could be better, and in my view it should, but in practice it is already the best there is.
None of these examples are services to small or lightly used stations, or in rural areas. These are connections within and between the UK's largest cities, and the large towns that surround them.