My experience from adding a SSD to a late 2011 MBP:
Measurements using Blackmagic Disk Speed Test
OEM 5400 RPM HDD: Write 68 MB/s, Read 67 MB/s
New SSD: Write 230 MB/s, Read 253 MB/s
Another problem that could effect performance would be a degraded internal disk SATA cable. If you install a new SSD and you do not see the speed improvements then take a look at replacing the SATA cable.
That is because of SATA II bus, SATA III is even faster.
Mid-2012 is gonna have speeds around 500 read and 450 write for 512GB drive.
Yes, OP, you are gonna experience drastic improvement in speed and responsiveness. It has to be seen to be believed.
Boot up time, application loading times, Logic/GarageBand library loading times, Spotlight search duration...all of that is gonna see significant decrease in duration.