Check out this to determine if you are in need of more RAM. Make sure you are doing what you typically would be doing with your Mac to get an accurate measure on your memory pressure:
Use Activity Monitor on your Mac to see if memory is being used efficiently and if you need more memory (RAM).
support.apple.com
If you are always in the green, then adding an SSD wouldn't have much of an impact on RAM or page swapping.
Does SSD make better use of RAM so that you can have more apps open when using SSD as opposed to Fusion drive even when using same amount of RAM? (64GB).
No. AFAIK, the OS does not treat an SSD different than a Fusion Drive when it comes to RAM management.
The difference would be how noticeable the page swapping would be due to different boot drive speeds.
Does it feel like you have more RAM when you use SSD instead of Fusion drive?
If you are page swapping, going from a HDD to a SSD would have a huge impact.
If your computer with the Fusion Drive is utilizing a lot of RAM already and it is page swapping a lot, then there could be a difference in speed in which a Fusion Drive page swaps versus a pure SSD.
Although, the way Fusion Drives work, a small portion of the SSD storage is supposed to remain free as working storage, so a Fusion Drive could have little difference than a SSD for light page swapping.
Although, if the SSD portion of the Fusion Drive is mostly full, that could impact write speeds, so maybe there could be a difference, but probably not noticeable because I think the potential bottle neck would be on the read side of page swapping (moving from the SSD to RAM), not write (moving from RAM to the SSD). Anyone else think that makes sense?