I feel obligated to mention that our own Doper @iiandyiiii wrote (in my opinion) a very entertaining and thoughtful Sci-Fi novel Spindown, which involved a station having to temporarily turn off gravity as a major plot point and all of the ramifications of doing so. (The title of the novel itself is a reference to that event.)
Wow, thank you very much for the kind mention!
Except that earth has 15 trillion people, and an oppressive government that’s a cross between the (literally!) Illuminati and a totalitarian state.
I think I’d just put myself in a stasis field and set it for 10K years or so…
This reminds me of a story I read, probably back in the 80s. The protagonist meets a “sorcist”, who is a member of a secret society of sorcists. He’s told that sorcists are to sorcerers as chemists are to alchemists. They had discovered the rational, repeatable rules behind sorcery, and so were able to actually control it, and predict the outcomes of new spells, as compared to just mixing random stuff together and seeing what happens.
Of course, being greedy bastards, they kept the secrets to themselves. 
Googling it looks like they only have 18 billion. The only reference I can find to 15 trillion people on Earth is an old theoretical comment by Isaac Asimov.
Shit, I was going by memory. I knew it was a lot. I guess not that a lot.
Lois McMaster Bujold’s “Falling Free” is based at the time that they discover artificial gravity, and this becomes a major plot point in the book.
The book is mostly about a genetically engineered group of humans, designed to live and work in zero Gee. They’re essentially slaves owned by a corporation, although they don’t really realize that until later in the book. At some point, artificial gravity is announced in the news, making these people obsolete overnight. The rest of the story is them fighting for their survival against corporate Evil People who decide to just pull the plug on their losses with this program.
And in one story set on high-G Jinx, the main characters mostly move around in wheelchairs, until they go to a high-end restaurant that has lowered the gravity to make its customers feel more at home.
Even Hearth has only 1 trillion.
Including autodocs (AI-controlled medical treatment devices) that are programmed to regard anyone who wonders if the autodocs are secretly being used to control the minds of the populace as suffering from paranoia and drugging them.
Since chemists ultimately based their science on atomic theory (and later quantum mechanics), do the sorcists have an overarching theory of how what they do works?
It was long enough ago that I don’t remember the details, but that was the general idea.
Another Star Trek reference includes multiple mentions in Enterprise, including turning it off for various fun (get your mind out of the gutter!), and finding “dead spots” aboard a ship where the gravity orientation was out of the normal alignment to hang out in.
And of course, a semi-realistic options for the Earth Forces ships in Babylon 5 (many alien races DO have antigrav tech), which have rotating sections and the Babylon 5 habitat has a rotating structure with low/no grav center for docking, and yes, it does come into play. 
Also a season 5 episode of Lower Decks.
And, Trek-ish, on The Orville.
Artificial gravity comes up a fair amount in the Sector General series about a multi-species hospital, because the ability to adjust it places a big part in life support.
It’s an important technology in the Schlock Mercenary webcomic. And very powerful, they can crush matter into neutronium, shred matter at range, create gravity “shields” and all sorts of other things.
Gravity manipulation is also a major factor in the Honor Harrington series. Artificially created gravity fields are both the primary way to make ships move, and their major defensive means. In the first few books, not much changes, but as the main character’s nation gets involved in a major war, they start putting a lot of research money into things, and find a few key improvements that gives them an advantage in the war.
To name just one example:
Capital ships run on fusion reactors which cannot practically be miniaturized beyond certain limits. Then someone gets the bright idea of applying gravity field technology to update an ancient and long-abandoned power source: fission. This makes the equivalent of torpedo boats launched from carriers practical, revolutionizing fleet tactics in a quasi-replay of the Pacific theater of WW2.
There’s a short story set in that universe, where a head of state is assassinated by sabotaging his ship’s inertial dampeners.
Back to the OP- The Stars My Destination.
Teleportation, explosives detonated by thought, lethal mental suggestions.
Going way back Jules Verne lambasted HG Wells for going to the moon using a magic substance the did away with gravity.
While using a supergun in his own story.
Which perhaps is more consistent with actual physics but would reduce the crew to a thin paste.
I still want a spindizzy…