"Except if the subject is static" is most of long exposure photos. Blurring is frequently the goal. Blurring waterfalls is a popular technique. As is blurring

"Except if the subject is static" is most of long exposure photos. Blurring is frequently the goal. Blurring waterfalls is a popular technique. As is blurring the ocean. Or streaking of light from cars. Searching for "long exposure" shows these techniques. They use tripods to keep some things static. Smartphones can make those photos just as well as cameras with the computational photography turned off. The limitation is using neutral density filter to make exposure work.