I try to shoot about once a month usually about 200 rounds 9MM.
Have you had any training by a good pistol instructor?? If not i HIGHLY recommend you look at that BEFORE choosing a pistol. Most ranges offer such services for not much money and are well worth the investment learning proper stance, grip, trigger control, etc AND help choose your preference between hammer fired and striker fired pistols once you understand advantages/disadvantages of each.
Then try out pistols that interest you. Even though you say you don't want to CCW that may change. I can't CCW for work either but I do outside of work.
Lot and lost of good choices in pistols. SIG SP2022 is another great reasonably priced option.
Though I love my metal frame SIGs, if I could have only one center fire pistol it would probably be a lighter weight compact poly frame pistol that can be great for CCW and range use. IMHO pistols such as the Walther PPQ/P99, HK VP9, and SIG P320C excel in that category.