And on the Snow Hill side, just the 2330 to Banbury and a 2334 to Whitlocks End. Very little in Birmingham that would necessitate anything into the small hours - most sport, arts and other social outings are likely done by 2300, and for the livelier side of the city's nightlife, anything before 0300 or so is too early!
I considered that 23:30 Banbury train a positive boon when I lived on the route of it's calling pattern, and certainly wouldn't have expected anything later, for the reasons that you state. When I moved further across the south west side of Birmingham to live on the periphery of the Warwickshire countryside, I accepted the fact that, on my then local line, the 23:34 to Whitlocks End would never prove useful because I lived one station beyond it's end of route and hence a taxi would always be less hassle to arrange from the city centre in the first place at that time of night.
Living as I do in Macclesfield now, I am chuffed to bits that there are trains home from Manchester at 22:50 and 23:14: If there are last trains back at round about traditional pub-kicking-out time then that seems alright to me. I still have difficulty getting my head around the fact that there are trains shuttling back and forth across the Pennines between Manchester and Leeds all night.
Having had to get back to the likes of Chinley and Whaley Bridge by taxi after late nights out in Manchester, I can appreciate the difficulties encountered by those living in the likes of Buxton, but it has to be considered that perhaps the comparatively low demand for late night connectivity to such relatively far flung rural locations isn't a particularly pressing concern to public transport operators, and is part of the trade-off for living in such bucolic areas.
From what I've seen and heard, the TOCs, and most pressingly the traincrew that have to work them, would much rather that even these existing late trains didn't run because of the unpleasant anti-social behaviour that is encountered on them, and there are increasing demands to deploy security staff on these last-out-of-town trains.