Tweetie 2 is one of the few apps with reasonably robust settings exposed to turn off or selectively use auto rotation.