To answer your original question, when I got my first handgun I thought it would be my last (silly me). For this reason I went after a versitile caliber (.38/.357), 6" sight radius good for target and maybe hunting some day and feel and it had to have adjustable sights.
The final choice was between the Taurus 608 and the Smith and Wesson 686+. The deciding factor was that I wanted my wife to be able to use the only gun in the house and she preferred the 686+ for size, feel and aim. As a newbie I was also hesitant about what I perceived as overly flashy ports and rib on the 608.
Now I would probably go for a 686+ in 4" or 6" for general purpose. The only difference is that the 4" is tuckable for CCW. The 686+ has the same grip as the 65 but is beefier up top.
I have an M66 4" which is similar to the 65 with the addition of adjustable sights. It is more manuverable for quick action but more difficult for marksmanship due to the light weight compared to the 686+. Somehow it is just one very friendly revolver, though, and keeps me excited.
Regarding ranges, Chabot and USI are the bigger ranges here. It is really interesting/puzzling to see nice ranges in Feinstein/Perata territory while the CCW friendly Orange County has withered from boasting several nice ranges down to one semi-outdoor range at the Sheriff's facility and some indoor ranges.
Chabot has a separate 200 yd facility, 90 lanes on the public range offering 100 yds down to 7, three 50 ranges with perhaps 35 lanes each rented by LEO, action pistol, cowboy and other groups. They have three or four shotgun ranges, but are not heavily used at this time due to issues with funding (shotgunners had been using income from other shooters to fund their activity).
USI has 5 or 6 shotgun ranges, a 200 yd multipurpose for members only, around 80 public handgun/rifle lanes up to 100 yds and IPSC bays for members only.
I have not even seen the Richmond shotgun ranges as I spend almost all my time on the IPSC bays. They have a more modest public range up to 200 yds.
All in all, with the clubhouse reloading discounts, at $25 ($20 for NRA members) USI is the best deal for the money. Chabot is set in eucalyptus forest above Oakland and by far the most beautiful in the area.
The rental ranges are all indoors and probalby cost $30 to $50 for a days shooting with one rental gun--same as I've encountered in Texas.