Hey, it really is the content that matters and if you have great and unique content then you can give it any address you want -people will remember it. If the content is similar to many other sites then other things like domain name, search engine marketing, link exchanges become much more important to getting traffic.
In the irony of all ironies of the domain name world, I find it interesting that one of the great resources for domain name speculators is a website with a .sc TLD!
.Com is still the grand daddy of TLDs and a good one will get you traffic no matter what content you have. .Net and .org are highly niched but may still take a bit of promotion to pull in traffic. All the rest of TLDs will take just about the same amount of promotion to get going.
To your specific question, the US is saturated in and identified with entertainment so I think the .us TLD is more appropriate.