Not sure what heat level you can handle. Can you handle jalapenos or something hotter or milder? Regardless, I recommend you google Scoville ratings. Many of these sites provide a list of pepper varieties and their heat level. (Wikipedia has a good but incomplete list.). If you use jalapenos and whether or not you can handle that kind of heat, you can use the the Scoville ratings to find varieties that might satisfy you and your family.
Like you, I was pretty much a heat/spice wimp until a few years ago when I started following the Pioneer Woman on the Food Network. Her recipes challenged me to try hotter varieties of peppers. Last year, I grew Fresno peppers, which can have a Scoville ratings of 2500 to 10,000, whereas jalapenos, if I remember correctly, has a rating of 2500 to 5000. I grew two of them in a big pot, and I was inundated. I used some instead of jalapenos in tacos and tostada's, gave a bunch away, and made a pint of Sriracha with the rest. (It was very tasty, and hubby told me to grow more next year.). I will never grow jalapenos again as I prefer the slightly sweet flavor of the Fresno's.
Best of luck with whatever you choose to grow.