Your question has essentially been answered, it's either and SLR with no movie mode, or a high end P&S.
As it's being discussed, I may as well chuck in my opinion on "superfluous" features in SLR's. I'm kind of on the fence here. Experience tells me that a tool designed for one job and one job only will perform far better than a multipurpose one, however, I welcome certain features, such as LCD live preview...
You can't beat a proper ttl viewfinder, but you can compliment it, and I feel that's what an LCD preview would do. If I had a dSLR with such a function, I would rarely use it - but there would be situations where I would find it infinitely useful, most notably at bizarre angles where it's either hard or just plain uncomfortable to look through the viewfinder.
For example, I enjoy looking at things from a different perspective by having my tripod extremely low on the ground. The only way I can see through the viewfinder at this level is either to lay on the ground behind the camera (not fun in a wet field) or to take "trial and error" shots to guess composition. A live preview would allow me (at an angle) to compose such a shot with far greater ease.