Would anyone happen to know what this song is, or what style of music this is? It's pretty rare I find a song that really strikes me in a flash and this one certainly did.

Trentemøller - Moan

House, probably minimal. IMO, house is at its best chilled out.

Tense house has its place too, though. I know some of my favorite trance songs are very grungy house songs with lots of transition between instrumentation and bass.
~

Try opening 2 of them at once. Then it will sound somewhere in between weird and awesome.