I've mostly switched over to Staedtler Triplus fineliners for general writing - they're much easier on my hands/wrists[1], but retain the convenience of ballpoints.
[1] I have a joint disorder, and writing more than a couple of lines with most ballpoints will make my fingers and/or wrists hurt. I can write for 20-30 minutes with the fineliners before they trigger the same issue.
They go for around $2 each.
If you want to feel fancier, the Pilot Metropolitan uses the same nib (in fact, since they don't sell replacements, you end up buying a pack of Varsities if you need to replace the nib).
Nowadays I use gel pens, best of both worlds. I definitely agree that ballpoint pens are hard on the wrists.
I do like the feel of writing with a fountain pen but never used one until I was an adult. I still prefer pencil for note-taking and rough draft writing.
I also don't see much appeal in fancy, expensive pens. The cheapest ones here are about €5 from a supermarket, so something for €15-20 is usually decent.