I have looked at buying property there in Rosarito before, and yes it is a pretty cool little beach. Besides bars and clubs, and a large market, I cant really remember any other activities in the town. So, If you can swing being close to the beach would be ideal, and you could certanly charge more if you were near it, not just $9 bed. The summers do get a lot of tourists, but the main draw is the beach.
Is there a bus that runs from the TJ airport down the coast, stopping in Rosarito?