Front Row had decided to show me Germany's "Top-Titel" and "Top Musikvideos" under the Music menu. Somehow the Front Row preferences stopped matching the iTunes Music Store country settings. Deleting Front Row's preferences and caches didn't do the trick, it only started a roulette game in which Front Row randomly sent me to another country. I got Japan next. Fun, but what if you want to fix it?
The solution is to edit Front Row's preferences. Open this file in Property List Editor:
~/Library/Preferences/com.apple.frontrow.plist
Expand "Root" and edit the MusicStoreFrontID value to 143441 for US. Save and close, and Front Row will see the change on the next launch.
Naturally, it doesn't have to be the US. Maybe you're bored with the domestic Top 40? For other country values, visit the country selector page in iTunes. Ctrl-click on a country, choose "Copy iTunes Store URL", and paste that into a text editor. Find the "storeFrontId" value at the end of the URL and use that as your MusicStoreFrontID.
By using Onyx, you can use it's GUI to choose which country you want Front Row to point to.
And in Terminal you can use the command:
defaults write com.apple.frontrow MusicStoreFrontID 143441
Great suggestions: Onyx (which I've never used), Property List Editor (free with the Developer Tools), and Terminal.
the terminal command actually did the trick for me, changing the frontrow.plst didn't work for some reason, so i recommend using terminal to set things straight. thanks a lot brent & scott!