Well, I saw them all. What a difference a few blocks can make! It's nice that we can all acknowledge that we might have experienced vastly different areas near each other, and that perhaps nobody is actually lying and trying to make anybody else have a bad vacation, right? I must say that I didn't drive any further down Rosecrans (maybe we're even talking about different streets, as we seem to be spelling it differently) than to our hotel and happily escaped the next morning (heading straight to Sea World, never to head back to that area again).
Did Rosecrans get better the further west you go? I would hope so, it certainly couldn't have gotten much worse than where we were. However, I do truly appreciate the people on here that say that I imagined the strip clubs and undesirables. It's nice to know that my opinions and experiences are valued.
The sandiego.gov site acknowledges the adult entertainment in that area as well:
http://www.sandiego.gov/planning/community/profiles/midwaypacifichwycorridor/
OP, stay wherever you want, but if you end up in a bad part of town in this area, don't complain that you haven't been warned. I'm out.
Yes, the further west you go, the more expensive and nice the area as you're getting into an area that's basically Coronado part II as there are a lot of retired Navy people that live in those parts.
It seems that unfortunately, you only ventured around the 2 blocks that aren't appropriate for children but the rest of the area is perfectly fine for sight seeing and my guess is you saw the strip clubs and assumed the rest of the area was full of strip clubs.
I've lived in SD pretty much all my life so I'd like to think that my opinion should be worth something and of course I can give the OP a complete breakdown but my post would run many pages if the OP were to ask me about each area that they planned on visiting.
I can appreciate that you found La Mesa to be acceptable for you and of course everybody's definition of acceptable is different but I would def not recommend La Mesa as a place for a tourist to stay. The Travelodge might have fit your needs and of course, I don't know what parameters the OP has to define an acceptable hotel but if it were me, I would not stay in La Mesa.
Again, I would say to stay in Hotel Circle as you have plenty of options to choose from from high end to economy and the location makes getting to Sea World and the Zoo easy. You'll also be close to other tourist places such as Old Town, Fashion Valley, Downtown/GasLamp Quarter, Seaport Village, Mission Beach, La Jolla Shores (a little bit of a drive), and many others.
To OP, I'm not sure what part of the US you're coming from, but if it's not from CA, I'd also recommend eating at In N Out as you're not going to find this burger joint in other parts of the states. I believe they're mainly on the west coast and there's one close to the Hotel Circle area. Since you have a car, it'll be easy to get to. It's like 10 minutes from Hotel Circle. Also, if you've never had a Mexican Carne Asada burrito, do yourself a favor and go to JV's. It's my favorite spot and you're not going to go wrong. It's also about 10 minutes from Hotel Circle. Keep in mind that San Diego carne asada burritos are not the same as anywhere else in the US. You'd think in Manhattan with all of the different ethnic groups that they'd be able to make the same carne asada burrito but their carne asada burritos are not the same. Buying them in Los Angeles aren't even the same.
My additional recommendations above are simply just a few suggestions of better ways to spend some of the 6 hours that you've saved by staying in SD instead of driving back and forth.