i would post something culturally relevant here, but your root instance is funny to me, so that will suffice instead :)

Yeah. There are Rock operas which are albums that tell a unified story, but not one which is meant to be acted out like an actual opera.

The Doors Who album Tommy was one of the first to be billed as such. As well as most of what The Protomen and The Mechanisms have put out.

re: dark side of the moon

It happens often, yes. But I wouldn't say it's "typical". Depends on what the artist wants to convey.

Idk if common. It does happen tho.

a lot of times albums will have a flow from song to song. Sometimes they just have a collection of different songs, usually a thematic album will have an overall feel to it.