Im not really sure what you mean by lying down? You're not always lying down. Surely gravity is less relevant when you're lying down anyway.

... I dont have a good understanding of physics but sci-fi novels suggest a few problems on small ships.

The first problem is the difference in gravity between your feet and your head. In a small command capsule like Artemis 2, your head might be near the centre at 0g while your feet are at the outside at 1g or even 2g. How hard does your heart need to pump blood? Would this create some kind of blood pressure problem?

The next problem is how it would "feel". Is it called the Coriolis effect?

In a small ship you might experience 1g, but it would feel like you're being spun around in a washing machine. Your ears would tell you that you're constantly changing direction and it would 100% fuck you up. In sci-fi the spinning thing needs to be large enough that some g-force is produced without you feeling that sense of motion, or at least for ot to be small enough that you get used to it.

Another problem I just made up is that if there's no gravity then 100% of the inner surface area can be terminals and readouts and equipment. If you create gravity then you need a floor to walk on which will use a heap of surface area.