Gaming

Warning: long comment ahead. Skip the first four paragraphs for advice on different roleplaying ideas.

I'm on PC and actually reached the same point as you, despite all the mods.

Took a few months, tried again a couple of weeks ago and got a few levels in before I got bored. Just decided to finish up a custom follower quest and be done with it. "Retired" to my home, put on regular clothes, sat in a chair, saved, exited the game. Canon ending for that character, then uninstalled.

I've done lots of different things, though. Custom races, muuuuuch better spell packs, overhauls to pretty much everything, and it's just kind of... meh now. There are some fantastic custom follower mods, and that area is actually kind of flourishing right now, but eventually you try enough and they become a bit... not boring, but not as novel as they initially were.

ESO was a nice change of pace, but burned myself out on that, too.

Anyway, advice? If you really want to keep playing, mess around with different races and playstyles. Stay sneaky, but use daggers. I personally never play 2H, but maybe spellsword could work for you.

Vampire hunter, maybe? Get Dawnbreaker early on (you don't need to find Meridia's Beacon and have her summon you; just go to her statue and she'll give you the quest to find it) and use that shit on every vamp you see. Restrict yourself to crossbows if you want to stick with archery, with the only traditional bow you use being Auriel's and only with sunhallowed arrows or something.

RP as an Altmer exile who spoke out against the Thalmor. Kill literally every Thalmor you see, if possible. Or RP as a Thalmor yourself. Makes that one main quest a bit difficult, but rationalize is it as they're sacrifices that you're making in order to become a powerful Dragonborn who will lead the Thalmor to decisive victory.

Maybe a Bosmer who sticks to the Green Pact (I don't know if it's available on PS4, but Imperious is a nice racial overhaul that really leans into this for wood elves). Like, avoid crafting anything that requires wood. Don't build a Hearthfire home and never chop wood. That means getting your arrows either from shops or scavenging. (Lore-wise, it doesn't actually matter that you're using Skyrim wood, but not out of character for a Bosmer to stick with the nature-protector thing.) Kill anything that lives, though. They're your food. Eat every single human heart you find.

Skooma-addicted Khajiit (or drug dealer who sells it). Or be a moon monk who focuses on unarmed combat only (this is actually a lot of fun, despite the animations being shit). When I say "unarmed", I really just mean no physical weapons. Magic and shouts can be used without issue to augment your "monk" approach.

Redguard who abides by their rules of not disturbing the dead. This one is difficult and nearly impossible because you need to kill a lot of undead no matter what. But do something like no grave robbery. Leave all urns, potions, miscellaneous items, chests, etc. untouched in dungeons (except main quest ones); they belong to their owners, even in the afterlife. Or roleplay as someone who's trying to follow in the footsteps of the Ash'Abah; a Redguard who puts the undead to rest. You're in Skyrim because you've been exiled due to being "unclean" for doing this.

(Like Bosmer, lore-wise it's kind of fine to be killing undead in Skyrim as Redguards mostly care about their ancestors and those who die in Hammerfell, but it's a change of pace regardless.)

Breton assassin who's killed kings, queens, princes, and princesses, looking to liven things up in a new province like Skyrim. Makes the last Dark Brotherhood quest a no-brainer. Restrict yourself to using conjuration and other magic schools instead of regular weapons. Want to stick with archery? Train your conjuration a bit, build up some magicka, and learn Bound Bow. In the meantime, you've got Bound Daggers and familiars.

There are a bunch of others. This is just race stuff, and I've obviously left out a few. I just don't care about Nords and I'm not familiar enough with Dunmer or Argonians to make any suggestions beyond "protect or kill Argonians as a Dunmer, kill all Dunmer and stay poor as an Argonian".

Quick edit: there's a channel on YouTube called "Skypothesis". They have like a bunch of different RP build suggestions (strictly vanilla, so no mods needed) that might be worth looking at. It's where I got the unarmed monk Khajiit from.

But honestly, I wouldn't force it. There's no rule that you have to keep playing and enjoy Skyrim forever.

Maybe play something a bit smaller and less overwhelming and come back to it later with fresh eyes. Or, yeah, go old school and play another TES game like Morrowind or Oblivion. The mechanics are different, though, especially Morrowind. Those aren't really "inevitably become stealth archer" games.