I don't mean to sound snooty or elitist, as I have relatively little knowledge or experience, but:
I downloaded the songs from the first page of this post and I have to say I found them all god-awful and really pedestrian, for want of a better word (born slippy is a classic though)..
Personally I think that although it's a step up from hardcore, mainstream dance is really pretty shabby unless you're absolutely muntered (and even then..)
I really rate just about any 2manydjs mixes (bootlegs included), as well as older but proven tunes by artists like Leftfield, Utah Saints, and Chemical Brothers. Plump DJ's play blinding sets too.
Good old Norman (Fatboy Slim) and Groove Armada have to be up there as well.
As for flash-in-the-pan tunes, Late Night Alumni - Empty Streets is very mellow and melodic, as is Orbital - Halcyon & on & on. Dope Smugglaz - The Word is more upbeat!
If you insist on mainstream, Crystal Method, and select Oakenfold (Delerium, Sex Drive, Ready Steady Go, Flesh) is cool too.
I guess it really depends on the mood, I prefer more mellow or at least really well produced stuff, if I'm going to dance like a bellend