Personally, there are lots of fluorescent fixture designs that I personally find aesthetically pleasing to me. In my case, here are the fluorescent fixture designs that I consider to be my favorites:

North American preheat fluorescent halfpiper fixtures from the 1940s:

https://www.lighting-gallery.net/gallery/displayimage.php?album=search&cat=0&pos=79&pid=72635

North American preheat fluorescent louvered fixtures with milk glass side panels from the 1940s/1950s:

https://www.lighting-gallery.net/gallery/displayimage.php?album=search&cat=0&pos=150&pid=227401

North American preheat fluorescent milk/ribbed glass panel fixtures from the 1940s/1950s like the one in this video although that particular one was converted to LED:

https://youtu.be/V0AJibBtyME?si=4oAxnNiRdlOoD54v

North American preheat fluorescent milk/ribbed glass halfpiper fixtures from the 1940s/1950s:

https://www.lighting-gallery.net/gallery/displayimage.php?album=6272&pos=107&pid=212534

Japanese reverse fuji 2 lamp preheat fluorescent fixtures from modern times:

https://roomclip.jp/photo/4len

North American preheat fluorescent shoplight fixtures with exposed ballasts from the 1940s:

https://www.lighting-gallery.net/gallery/displayimage.php?album=search&cat=0&pos=1&pid=210038

North American preheat fluorescent troffer fixtures with ribbed glass diffuser panels from the 1940s/1950s:

https://www.lighting-gallery.net/gallery/displayimage.php?album=search&cat=0&pos=534&pid=208053

Japanese preheat circline fluorescent pendant light fixtures:

http://www.soukotengoku.com/re-026.htm

Japanese preheat circline fluorescent chandeliers:

https://blog.goo.ne.jp/opn2goo/e/2be85479b2810e23bda56c2057362c67

Japanese preheat fluorescent outdoor wall sconce fixtures that use linear fluorescent tubes:

http://retorochan.blog105.fc2.com/blog-entry-390.html

European preheat fluorescent street lanterns:

https://www.lighting-gallery.net/gallery/displayimage.php?pos=-226853


What are your favorite designs for fluorescent fixtures?

I really like the older waterproof fixtures made for industrial use, especially with the clear glass tube over the fluorescent tube. I can't find the image for it though...

the ones on older merchant ships they have 2 or 3 glass tubes and a cast end assembly with caps you remove to access the lamp inside F40T12 tubes
we had a similar setup for the PIT at a shop I used to work at
also partial to circline fixtures EX "fancy" ones like the Japanese ones shown above

Probably the drop lens troffer. They have nice even light spread and when mounted in a drop ceiling, give it a bit of character.
My other favorite would probably have to be the plain old single lamp 4 foot striplight. Magnetic or electronic, T12 or T8, it is a simple and flexible way to get a good amount of light for tons of different applications.