You wont get an atmosphere in hospitality, you probably wouldn't get any atmosphere anywhere else to be honest unless if iit's a really big match (quarter finals of Europe or later / playing a big club towards the end of the season if we're still in with a chance).
If you go with a Thomas Cook match break you'd be next to the Kop and you'd have the locals section behind you. I'd guess that would be best for atmosphere but 95% of the time it's shite all over the ground.
Noticed they've still got tickets for the derby. Atmosphere for that wont be quite as shit as a run of the mill league match.