Your the one who specifically chose to claim that firebolt has better dpr than a fighter with a bow.. Your going to need to explain your math to come up with less dpr from this (1d10+MOD)+( d10+MOD) at up to 150 feet of range
View attachment 125120
than this
View attachment 125121
2d10+nothing no second attack/second bolt.
Listing dp
R numbers is meaningless if they are so obviously wrong that they fail to include things like a fighter's extra attack but are comparing a fighter to a wizard. What you excellently raise however is how bad 5e's cantrips are for full casters because cantrips have all of their scaling built into the cantrip by character level rather than meaningful class abilities like the extra attack feature sneak attack & so on. It's a situation that favors a gishy build & prevents casters from developing that on their own in a way notably different from a gish
as to your bizarre inclusion of warlock & attempt to jump from wizard to warlock, you'll get no argument that eldritch blast is anything but broken on ways thst complicate other areas so don't waste everyone's time when it was raised all the way
back on page 1 where I
agreed in detail. Otherwise... don't waste everyone's time with damage per
round comparisons between a fighter who takes archery style with a 10 in their relevant stat or stats that doesn't bother with extra attack.