GoodSirTheSir has a good response about the mechanics, but if this is something you really want to do then you can use RAW to make it work.
Advantage and Disadvantage
One of the biggest boons for this is that Advantage and Disadvantage do not stack, but instead cancel out.
Basic rules p. 57:
If circumstances cause a roll to have both advantage
and disadvantage, you are considered to have neither of
them, and you roll one d20. This is true even if multiple
circumstances impose disadvantage and only one grants
advantage or vice versa. In such a situation, you have
neither advantage nor disadvantage.
If your spellcaster is blind, they will always have disadvantage on attacks. However, if they find a way to give themselves advantage on the attack (which is pretty easy in 5e with helping, spells, and DM fiat), then the disadvantage goes away and they're back to making regular attack rolls. They will never be able to get advantage on an attack, but spells like Bless can help make up for that. An additional bonus is that as long as they can give themselves advantage in some way, they will never ever be forced to roll attacks at disadvantage.
Unseen Attackers
5e, in my opinion, has very strange rules for unseen attackers. Being unable to see someone seems to have no bearing on whether or not you are aware of their location. Furthermore, there is nothing that states that being unable to see someone has any negative effect on your combat efficacy at all. Other than failing checks that rely on sight (which, other than counting birds a mile away through a plate glass window is 100% up to interpretation and thus DM fiat), you can be blind as a bat and still have perfect situational awareness. In fact, there are some situations where it is easier to detect someone if you can't see them than if you can (passive perception vs active perception for hiding, using the 'Lucky' feat, etc).
Here are the rules for attacking unseen attackers:
When you attack a target that you can’t see, you have
disadvantage on the attack roll. This is true whether
you’re guessing the target’s location or you’re targeting
a creature you can hear but not see.
This is a very important part. It states that you have disadvantage whether you're guessing the target's location, or whether you can hear but not see them. In your case, you can hear but not see the enemy, so by RAW you don't ever have to guess where they are. You just 'know' their location.
If the target isn’t in
the location you targeted, you automatically miss, but
the DM typically just says that the attack missed, not
whether you guessed the target’s location correctly.
Again, the above rules state this only applies to when you have to guess at the target's location, which is not the case when you can hear the attacker.
So, as long as you can hear the attacker, you always know where they are.
Hiding
The biggest downside I can determine is that if you're blind, anyone can hide from you at any time as a standard action. Basically, you're granting the enemies permanent invisibility:
An invisible creature can’t
be seen, so it can always try to hide.
If you're facing smart enemies, they will realize this eventually and make stealth checks even when they're standing next to you. If you fail the perception check to detect them, they are now 'hidden', and according to the rules that means that you no longer know their location (and would thus be beholden to the 'attacking unseen targets' rule above).
So, if you concentrate on giving yourself advantage, and giving your enemies disadvantage, you'll have almost the same efficacy as if you were never blind in the first place.
There's nothing in the PHB that says you can't.
The Blinded condition (PHB p. 290) says:
- A blinded creature can’t see and automatically fails any ability check that requires sight.
- Attack rolls against the creature have advantage, and the creature’s attack rolls have disadvantage.
The blinded condition doesn't prevent you from casting any spell per se.
As you pointed out certain spell like Hold Person explicitly state "a target that you can see" therefore any factor that prevents you from seeing the target makes the spell unusable.
As you also pointed out, Acid Splash doesn't have such a requirement. The spell description states that you hurl a ball of acid but doesn't require any attack roll, so you are also safe from the second effect of the blinded condition.
Note that the line of sight rules still apply; see the "Targets" section on PHB p. 201.
Despite the name, line of sight is about walls and other objects that impair vision, not the state of your eyes.
Best Answer
Two routes for you to find this, each with their respective drawbacks.
Search dndbeyond
dndbeyond does have free-text searching that can be filtered down. If you go to this link: https://www.dndbeyond.com/search?q=you%20can%20see&f=spells&c=spells it provides for you a list of all spells that includes the words 'you can see.' However, dndbeyond does not do phrase filtering, so you're going to get some extra results in there.
Personally, I wouldn't trust this option to catch everything. Dndbeyond's full-site-search is honestly a bit rubbish. I've had a experiences where it just doesn't find what I'm looking for, or leaves out relevant results. It's a good start, but I wouldn't count on it to be all-encompassing.
Google-fu
A bit of creative Google-fu can help you here as well. If you go to google and use the following search phrase...
It will exclusively search through all spells in dndbeyond for the exact phrase "you can see." As a downside, this also includes homebrew spells...and adding a -homebrew to the search takes everything out, because the word 'homebrew' appears on every page on dndbeyond.
Alternately, if you're okay with limiting the list to publicly available data (i.e. spells covered by the OGL) and don't mind the risk of it being slightly inaccurate, you can refine your google search to target roll20's archive of spells instead. Make the search term...
A quick look at the google results looks a lot cleaner...no homebrew. It might pick up a few class features in the process (since it isn't filtered on spells), but that should be the minority.
Conclusion
Neither of these options are perfect...but both are significantly better than manual perusal of the entire spell list.