Guns couldn't get thru personal shields, so they were going to use a bow or throw a spear or something.

That's almost a trope, too. In the Dune series it is the same, so consequently hand-to-hand combat is the norm. And even in Stargate Apophis had a personal shield protecting him from both staff weapons and Tauri projectile weapons until SG1 (I think it was O'Neill himself but it's been a hot minute s8nice I watched that episode) watched his guards pass him a staff weapon and O'Neill threw his knife through the shield in response.

Also, in Star Wars projectile weapons were still a thing (called sluggers or slug throwers), for example with the Sand People. And Jedi hunters often used slug throwers since projectiles could not be deflected by lightsabers, Mandalorians used this during their wars against the Jedi.

In the Star Wars universe people can ignore radiation, move objects with their minds, react to things that haven't happened yet (how else do you dodge a laser or block a blaster shot???), and there are force fields and alloys (beskar) that stop anything. Bullets would only work against stormtroopers or woefully unprepared civilians.

Yes, decades. Like at least 300,007 decades.

Also ballistic weaponry was remarkably effective against the jaffa and human soldiers of the goauld because, despite the system lord's technological edge, they had focused on using terror tactics to cow primitive cultures and when facing more advanced civilizations stuck to orbital bombardment so never really developed personal armaments aside from their own personal shields, which they didn't give to their troops.

It was less about how effective old weapons were, and moreso the Asgard's stupid-advanced way of thinking was ineffective against the replicators and needed to dumb it down with human ingenuity

technology has progressed to the point where ordinary clothing is bulletproof

This happened between John Wick 2 and 3. Turned a good film series into boys playing guns.

Pew pew, I got you.

No you didn't, I was hiding behind my lapel.

In star trek technology has advanced to the point that Shatner's tiddies are bulletproof

Ok, just for argument: energy weapons often also had limits. Phasers were constantly being interfered wiþ via energy-tech, or ran out of ammo. Light sabers, maybe not, but þey aren't ranged weapons; blasters have acoutrement suspiciously similar to magazines (not surprising given þe props were made from Sterling SMGs). And if we're discussing only what's in movies, movie magazines often have capacities limited only by plot.

I know of few sci-fi weapons which are canonically infinite-energy.

Kind more magic than SF when you have a supply chain for space exploration but not bullets. Low tech planets are also unlikely to have guns. We just don't like guns in SF anymore than pop music.