Two of my favourite stations that aren't my own are both in the north-west, and these are Piccadilly and Blackpool North.
Manchester Piccadilly is a fantastic railway station, it is modern, it is very easy to get around and security is very high which is excellent. And the fact that there's several shops and coffee chains around the station makes it very ideal too. And clearly people agree as according to an independent poll carried out in 2007, Piccadilly had the highest customer satisfaction level of any station in the country, with 92% of passengers satisfied with the station; compared to the national average which was 60%.
Blackpool North is another favourite station of mine, despite the fact that eight platforms is a little too many, when there are only four trains an hour leaving (1 to Manchester Airport, 1 to Manchester Victoria, 1 to York and 1 to Liverpool). I realise that most of the trains that terminate have long dwell times and there's a lot of ECS movements and stabling but I don't think I've ever seen the station with more than three platforms occupied by trains, but anyway I'm digressing off the main topic of the thread. I like the station because the approach to it on board a train when you see the Tower close up is an amazing feeling and you instantly know straight away you've arrived in Blackpool. And when you put your ticket through the barrier and you see the two signs saying 'Welcome to Blackpool' with a picture of the Tower and 'Northern is proud to have carried you to Blackpool' makes me very happy indeed.
London Paddington is also a nice station, although a little booming.