I know Postgresql very well... But I rarely use psql. I still use pgadmin.
That said, I never load CSVs into Postgresql. I still tried very hard to load CSVs into Excel.
My personal opinion is that people have their preferences. If they prefer command line tool, Superintendent is probably not for them.