What are the best areas or types of accommodations to consider for tourists visiting Venice Beach, Los Angeles, offering a variety of options in terms of budget, amenities, and proximity to key attractions such as the beach, boardwalk, and local shops, while also ensuring comfort and a memorable experience?