It does work well once it's all dialed in but that is a huge pain in the ass. I just opened it after a long time to check my psx settings and it took me a minute, it's pretty arcane in a bad way.
That being said the beetle core has some options that makes many games look very good and play almost brand new although you have to use the vulkan renderer as under opengl there is no difference.
These are my psx settings that work well and I have 1070 so should be fine for 1060:
Load an iso first, go in to do the options then go under overrides and save as core overrides, in that case I'm getting same options across psx games with beetle core.
It's phenomenal on a pi or android tv or something like that. I'm not sure if it's worth it being the size that it is and how tedious it is to get configured across cores on a pc generally but in your use case, probably. I keep it basically just for beetle psx as those options make things like armored core, front mission, and all the rest look excellent.
All the best.