Living Daylights and On Her Majesty's Secret Service the two most underrated Bond movies.

I also love how bananas the final act goes (no spoilers if you're still watching but... wow.)

Agreed. And these practices burn out SMS as a mechanism for GOTV and persuasion, which is very very important in the current technological era.

My incredible restraint in submitting an only 8 minute song from Jurassic Park seems so temperate in comparison now.

Trauma response. We literally don't believe anything can be good.

Yeah, like Worf has a collection of specific RECORDINGS of Klingon Opera he likes.
I much prefer this version of the conputer.

Right, which is super similar to if we ask (Siri, etc) to play music for us. It just starts playing (Spotify) and chooses what we like.

We're living in the Star Trek future... except we're the Ferengi instead of the Federation. Sigh. I'm voting for Rom for our next Grand Nagus.

Anyway, so back to the original question: is the ship's computer and holodeck more like a library of music and games/programs or does it rely on AI to generate new music, dialogue, stories, etc?

So here we have a musical AI that interpolates his own music. Although maybe like the Voyager EMH, the DS9 version has developed more personality and awareness from being on for so much longer than normal?

Counterpoint: Vic Fontaine.
He claims to have a small amt of self awareness AND creativity- able to play "I'll Be Seeing You" in dozens of styles for Nog.
Assuming that program isn't exclusive to Quark's bar, it means (tens of thousands?) of Vic programs could exist through the galaxy, all unique?

So it seems like the holodecks don't really use AI either (and apparently "Holonovel Author/ Programmer" is a job people do in the 24th century. (Sounds great! Sign me up!)

Again, it appears from how the Voyager crew experience this holodeck program, the artificial characters (NPCs?) have fairly limited programming in how they react to the "player character" and their decisions. It seems more similar to a classic BioWare RPG or Baldurs Gate 3 or something- just 3D.

And it means the holodeck computers are generally not capable of creating characters with true Artificial General Intelligence, much less Superintelligence.
Similarly in "Our Man Bashir" the crew get stuck playing characters in a 60s spy thriller.
Which brings us to Tuvok's holonovel:

So when the computer is asked to create a villain capable of defeating Data, it creates Moriarty, who has a level of sentience that everyone is shocked by. So it stands to reason the computer generally is not really a true AI (and there are several episodes about the dangers of this!)