FFVII springs to mind. The entire opening in Midgar was very memorable. I also liked Half Lifes opening. If only because you can blow up a Microwave meal for no apparant reason.