Sad to say, but Houston is lame in the entertainment department. Great for important things like hospitals and energy, but we fall short with fun stuff. Out-of-towners usually call us boring.
U2 recorded a video in the Astrodome: http://en.wikipedia.org/wiki/Stuck_in_a_Moment_You_Can't_Get_Out_Of
I also know Motley Crue's Home Sweet Home and Aerosmith's Blind Man videos were recorded at the Summit.