This IKEA curtain rod is a favorite of mine. It's less than $30 and looks great as is in a brushed nickel finish, but I especially love to paint it with Rustoleum's Metallic spray paint in brass (not gold! too pink).
You can pick up a bag of inexpensive rings to also paint while you're picking up the Rustoleum at Home Depot.