With Linux, you can literally do anything that you want. And lots of people are already doing just what you describe, making pretty and functional Desktop Environments and compositors for anyone to use. As a beginner I’d encourage you to check out all the major Desktop Environment options first. You can usually get any of these in most major distros (Cosmic may be less available and mature right now).

https://www.gnome.org/

https://kde.org/

https://system76.com/cosmic/

Article with others https://www.geeksforgeeks.org/best-linux-desktop-environments/

Then you can get into compositors, plugins, and other customization, where you can make your system look almost exactly how you want it:

https://hyprland.org/

https://extensions.gnome.org/extension/6099/paperwm/

https://github.com/Bismuth-Forge/bismuth

https://github.com/YaLTeR/niri

These just happen to include tiling because I love tiling haha… I’m sure there are other non-tiling projects you could try out as well.

Edit: sounds like you may have already rejected a bunch of the status quo Desktop Environments as too boring haha. Then I would encourage you to check out Cosmic, and then the experimental tiling compositors I listed above… I’m sure you will find them unique at the very least!