It can depend on the market and what you are looking for. If you are looking for something a little more unique in a smaller market, then an agent might be able to help you.
If you are in a larger market and not all that particular, you can probably do fine without an agent. Check out places like Craigslist. It often has many times more apartments for rent than what is in the MLS.