Never been to Pismo Sands but we spent a couple nights at Morro Dunes recently and liked it. We stayed in one of the loops along Embarcadero and had an awesome view of Morro Rock right out our window. Each loop has a gate to the street, so access to the beach across the road is very convenient. The gates are locked after dark and opened again in the morning. Staff was friendly, store was well-stocked, plenty of restaurants nearby, and my wife gave their shower facilities a thumbs up.