By pkgs.org, Opera is in the App Center
I recommending watching this video gaming on Linux.
I can't help with After Effects right now because I'm not really into video editing. The best open souece video editor is Kdenlive, but there are others non-free for Linux, like DaVinci, and another which was used to make Titanic. But DaVinci doesn't package for Solus nor do I know they allow repackage.
Anyway, except for Adobe and online games, I say you could try Wine on the Windows version in the last case. So maybe using wine on the Windows version of DaVinci or in Hotfilm?
The last time I saw, wine on Solus had a bug for me, I don't know if it's corrected, but I never not try to do the correction:
sudo eopkg wine wine-32 && winecfg
Then in Winecfg I load the kernel32.dll in the Libraries, save, and it's fine.