For me, superhots produce less but part of this may be the longer ripening time cut short at the end of my growing season for pods produced later than 2/3rd of the way through the season.
Beyond that it is mostly about soil quality and amount of sunlight (plus a good growing season). These matter more than the specific pepper, grow what tastes good to you and keep in mind that if your friends are chiliheads they will appreciate the hotter varieties but if they aren't, you may not be sharing more than one pepper with them.
Personally, I prefer not to grow things like Cayenne, Tabasco, or White Habanero any longer because the small pod size makes for a lot more labor processing them if you wish to remove the seeds or check for mold inside. Sure they look prolific but when it comes to pod weight per plant per season they may not actually produce much if any more.