The Lions Gate Bridge is no more dangerous than any other bridges, even tunnels we have in the GVRD.
To be honest, I actually feel safer driving on the LGB than in the Massey Tunnel. I've seen and heard too many horror stories centered around the Massey Tunnel to drive recklessly around that area. A family friend of mine knows an individual who miraculously (not really, because Volvo XC90

) made it out alive from a serious head-on collision inside the Massey Tunnel. After hearing about that incident, I no longer drive on the counterflow lanes, regardless of whether or not it is rush hour. I'd rather spend an extra 10-15 minutes on the road than put my life on the line. The entire stretch of Hwy 99 Northbound from the border to just before the tunnel is also pretty much devoid of police presence 24/7/365, so it's pretty common to see people not bothering to slow down after entering the tunnel area, blasting through at ridiculous speeds and changing lanes in the tunnel weaving in and out of traffic like a madman.
Strangely enough, I feel very calm while driving on the LGB compared to the crowded Alex Fraser and the horrifying Patullo. It's definitely the drivers that make a particular roadway dangerous, NOT the road itself.
Though, the Patullo is pretty damn stressful to drive on
EDIT: I will say however, there's ALWAYS ALWAYS this one idiot who hogs up the left lane in the tunnel going 65-70km/h and is NOT exiting the highway after coming out of the tunnel, just gets my blood boiling.