Exactly, while an interesting exercise, that would be insane!
But built from Lunar/asteroid material ? Sure, you can build 8 by 32 km cylinder from steel with dirt for shielding with that has a standard earth gravity just fine. No exotic materials required:
Why on earth would you try that?