Radisson SAS has views over the apron - the higher the better as you are over most obstacles. You can get rates around £90 per room, which is a little on the high side but it's a very nice hotel and has good views. I've stayed there twice and would definitely go back
As for photography, you really want to get to the south side - you are on raised ground running the length of 24L/06R and can see directly on to the runway. You really need a car to get here (taxi would be an option but expensive and have to find one to get back!). First time I went, I took my own car and drove to MAN
, so just parked that, but second time I hired a car. Parking is possible after you come out from under the tunnel (that goes under the runways), but in busy periods, there may be no spaces left and I think it's a bit dubious as to whether you are allowed to park there - never heard of many problems though.
The best thing about the south side is that you can walk the length of it (quite long though!) and get everything from 24L lineups to shots half way down, to rotation shots, and even go around to the lights the other end (06R) and gets shots up the runway. The light is right behind most of the day, and when it does go around later in the day, you can go under 24L/06R and face the other way and get the sun behind again.
There's also the aviation viewing park which has good views of taxying aircraft and also aircraft on 24R/06L. However the sun isn't behind most of the day (only late on) and it can get very busy with families. Still worth a visit though!