How does it compare to SkyRe?
I haven't tried any of the others, but the general consensus (pretty much 100% agreement) in the SomethingAwful thread is that SPERG is the better alternative. It's more lightweight, sticks closer to the original game's feel, allows for a wider variety of play styles, has more robust code and plays better with other mods as a result.
Most importantly, it encourages/allows for a varied play style in a single playthrough. Pretty much any type of character I can imagine is viable with SPERG.
Unarmed? Check - pickpocket perks can boost unarmed, and weapon perks give some global boosts
Single weapon + spell/unarmed? Check - pickpocket perks give boosts with one hand free
Dual wield or swap between different weapon types? Check - weapon specific perks give some universal boosts
Agile melee? Check - There are perks which increase move speed, perks which reduce sprint stamina consumption, and a perk that makes power attack perks also boost normal attacks, making dodging and sprinting a viable alternative to block/power attacks
Any weapon stealth? Check - sneak attack bonuses are upped for unarmed and 1H, and one-hit kills with twohanders cause an AOE fear effect
Pure mage? Check - Mage trees now have significant cross-tree bonuses, and the illusion and alteration trees are actually worth a damn. Including a permanent mage armor perk which makes alteration go up when hit.
Summoner? Check - Summons get meaningful boosts from conjuration, speech gives a follower/minion aura, and illusion has phantom monsters and floating swords
Shout centric build? Check - Speech boosts shouts.
The list goes on - there's a ton of things you can do. The perk list (for the latest beta) is here: seorinwastaken.com/sperg/perktrees.html
The mod can convert old characters seamlessly on load and has a built in respec, so it's easy to make a back-up save and try it out.