Someone else will have to create the Wiki and shift the post since I lack the privileges to do either. I will however keep adding to the database:

Sydney

Starwood:
No of properties: 3
Geographic spread: All in central Sydney, good for tourists and business only
Price/Portfolio: Low end missing and mid range lacking

Hyatt
No of properties: 1
Geographic spread: One gorgeous property in the best possible location, nothing else
Price/Portfolio: Low/mid/high end all missing. Single ultra high end option

Hilton
No of properties: 1
Geographic spread: None, single property in great location
Price/Portfolio: Single high end property.....

Marriott
No of properties: 3
Geographic spread: Not great
Price/Portfolio: Low end missing, Mid range lacking

Accor
No of properties: 42!!! (Bigger than every other brand combined!)
Geographic spread: Blanketed the city
Price/Portfolio: Very very good
Warning Note: Lot of hotels do not participate in LeClub at all. Others are limited participants.

IHG
No of properties: 9
Geographic spread: Very good
Price/Portfolio: Good

Club Carlson
No of properties: 2
Geographic spread: Not good
Price/Portfolio: Low and mid range absent