As with many things WINE, the answer is "it depends" (silver is workable, but still has very significant flaws). You can always try it out yourself, and I recommend walking through the HowTos that people post in the listings and the known bugs. The two programs you asked about are particularly difficult, as they are incredibly complex and use many libraries that are specific to only their own application, meaning their implementation in WINE is not priority (WINE tries to be as compatible as possible, targeting the broadest stuff first before gradually narrowing). Most programs "just work" through WINE, but these two in particular have been struggles to get working for years. Development is always happening, so I recommend to try it out if you're curious if it'll work for you. And if not, perhaps it will be better in a couple years.
The token recommendation for apps that don't work through WINE is to try to find alternatives that play nicer. After all, supporting the anticompetitive business practices of Adobe or Autodesk spits in the face of Linux and the libre software movement as a whole. If you are able to reasonably find alternatives, then that would be ideal, but I find that recommendation quite naïve. As an alternative, you can run Windows in a VM from Linux, or you could dual boot if you only need to use these programs occasionally.
Bottles is really just a frontend for WINE with some extra features baked into the GUI to make the experience better for the end user. Compatibility in Bottles will still be determined by the compatibility a program has through WINE.
Your best bet for finding compatibility with WINE (and by extension Bottles, because that's what it uses) is through their AppDB:
https://appdb.winehq.org/objectManager.php?sClass=application&sTitle=Browse+Applications&sOrderBy=appName&bAscending=true
Here is the page for Photoshop (and all its different versions) and here is the page for Fusion 360 (or rather, a version of it being developed to work with WINE)
As with many things WINE, the answer is "it depends" (silver is workable, but still has very significant flaws). You can always try it out yourself, and I recommend walking through the HowTos that people post in the listings and the known bugs. The two programs you asked about are particularly difficult, as they are incredibly complex and use many libraries that are specific to only their own application, meaning their implementation in WINE is not priority (WINE tries to be as compatible as possible, targeting the broadest stuff first before gradually narrowing). Most programs "just work" through WINE, but these two in particular have been struggles to get working for years. Development is always happening, so I recommend to try it out if you're curious if it'll work for you. And if not, perhaps it will be better in a couple years.
The token recommendation for apps that don't work through WINE is to try to find alternatives that play nicer. After all, supporting the anticompetitive business practices of Adobe or Autodesk spits in the face of Linux and the libre software movement as a whole. If you are able to reasonably find alternatives, then that would be ideal, but I find that recommendation quite naïve. As an alternative, you can run Windows in a VM from Linux, or you could dual boot if you only need to use these programs occasionally.
Bottles is really just a frontend for WINE with some extra features baked into the GUI to make the experience better for the end user. Compatibility in Bottles will still be determined by the compatibility a program has through WINE.